How i can change the pivot colum?

I want to put my first column's recorsete (that i extract from db SQL server) in the column, where in the example is a secuential code. It's possible to do that? Please a need help!

Thanks

Sorry I don't understand what your problem is. Recorsete?

As far as I know if you want a Pivot table effect you'd have to pass the data to the grid, meaning, the data you extract from the SQL Database must be in pivot format already.

That is sometimes tricky to do, but it's possible. Depending on your T-SQL skills I'm sure you would be able to cope.

Unless I'm a bit loopy and I missed the whole Pivot table function?

Thaks for you answer!

(Sorry I'm from Venezuela and i don't speak english very well)

how do that? the change the pivot of my Recordset.

Thaks

Hi it's me again

Really my intention it's keep fixed the first column ( key register ) while I move the scroll bars to the righ to see the rest of the information in the table.
My first idea was to put the data key register in the pivot column, but if I can freeze the first column it's OK for me

Thanks.

Susana,

If you search the forum for "Fixed column" you will see that this has been discussed at great length. Here is one of the threads:

http://www.activewidgets.com/javascript.forum.1393.10/fixed-columns-in-ver-1.html

thank you
I'm very happy.