-
September 29th, 2004, 02:37 AM
#1
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
-
September 29th, 2004, 08:49 AM
#2
Re: Pivot Table
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.
JP
Please remember to rate all postings.
-
September 29th, 2004, 10:35 PM
#3
Re: Pivot Table
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
-
January 15th, 2014, 10:10 PM
#4
Re: Pivot Table
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.
-
January 16th, 2014, 12:08 PM
#5
Re: Pivot Table
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|