CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5

Thread: Pivot Table

Hybrid View

  1. #1
    Join Date
    Jun 2004
    Location
    Coimbatore
    Posts
    25

    Exclamation 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

  2. #2
    Join Date
    Jun 2002
    Location
    Clane, Ireland
    Posts
    766

    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.

  3. #3
    Join Date
    Jun 2004
    Location
    Coimbatore
    Posts
    25

    Exclamation 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

  4. #4
    Join Date
    Jan 2014
    Posts
    3

    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.

  5. #5
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    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.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured