Pivot Table

Hi,

I am Using Pivot Tables in my Module to Show data.
I have Shown a general Template.

I have provided additional Fields so that user can drag and drop the required fields in to the pivot table and remove the unneeded ones.

Next time when it's Loaded the default template get's loaded.

I need to store the user defined Pivot view somewhere and Load it again
when requested. how to do this. Is there any way to store the user defined Pivot View and fetch it back.

Help Please
Thx in Advance

Ashok

Are you using ADO? I don't know if this is of any use to you, but there is a recordset operation .SAVE, which allows you to save the contents of your recordset to a file, and then .RESTORE which restores it back to a recordset later.

Hi,

I need to store the layout of the pivot view.
I am using an SQL Statement to show the contents in pivot.
No problem with recordset. I use same sql statement all the time.


Ashok

It is said that pivot grid control is something with similar functionality to the pivot tables. You may try adding a pivot grid control at this time.

I don't think that is a good idea. That would allow the user to use SQL INJECTION and get/put data into your table.

If there are a set # of fields, you could use parameters, but that is somewhat limited.