Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Documentation for PivotGrid.dll

Documentation for PivotGrid.dll

Documentation for PivotGrid.dll

Dear Friends,

I have someone who has a purchased copy of a library called PIVOTGRID.DLL which generates Excel Pivot style reporting interface. There are a few programs also make use of this. But now, I have to write another program for which I need to know the details on the methods/properties of this DLL. The existing programs are using only the basics and I believe there are more flexibility available in this library.

It creates the library object as "x = CreateObject("PivotGrid.PivotGrid"). However, the intellisence associated with the methods don't give much information on the valid user values or static values.

Anyone among our friends knows about this?

Thank you,

RE: Documentation for PivotGrid.dll

Hi Rajesh,

Open the Object Browser from the Tools menu. Click the left-most button in its toolbar, then click the COM Libraries tab. Select the pivot grid in the resulting list, and click OK.

You should now see a window containing all the properties, events, methods and constants of the class. The panel at the bottom will show things like the parameters and returned values from methods, or the data type for properties, along with a short description of what it does. (How useful that description is depends on how much information the class's author provided.)

This isn't the same as a full help system, but it should be enough to get you started.


Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Documentation for PivotGrid.dll

Dear Mike,

Thank you. I didn't think about that. I checked it. But it doesn't give me enough information. It shows the method names but when clicked nothing is shown below. I think it was not incorporated into the DLL.

Now, is a documentation available for this DLL somehow?
Anyone, any idea?


RE: Documentation for PivotGrid.dll

Dear mgagnon,

Thank you for your time.
The documentation is great. But when I just browsed a bit, I didn't see any reference to the declaration and methods usage forms for Visual Foxpro in that.


RE: Documentation for PivotGrid.dll

Dear Gagnon,

That doesn't really co-relate with the sample code I already have (it works too without any issue). I am pasting a sample for you just to look at.

CODE -->

__GRID_ROW_AREA    = 0
__GRID_COL_AREA    = 1

x = CREATEOBJECT("PivotGrid.PivotGrid")

x.setGridParameters("from_name",    "Transfer From", __GRID_FILTER_AREA, 0)
x.setGridParameters("product_name", "Product",       __GRID_ROW_AREA,    0)

x.setGridParameters("voucher_date", "Date",          __GRID_COL_AREA,    0)
x.setGridParameters("to_name",      "Transfer To",   __GRID_COL_AREA,    1)
x.setGridParameters("Quantity",     "Quantity",      __GRID_DATA_AREA,   0)

But I was wondering if there is a proper documentation for the usages as I see many features (including print/page setups, exporting to various formats like HTML, EXCEL etc) at run time but don't see any property or method I can really modify and get it to work.

Too, the 'setGridParameters' method intellisense shows
'(FieldName as String, ColumnHead as String, Position as DisplayArea, z as Number, [spl as String=""], [w as Number=100])'
Though the first 4 parameters are clear to me, not sure about the rest!


RE: Documentation for PivotGrid.dll

You can contact their support and perhaps they can answer your questions. I am not familiar with that control, unless someone here else is.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483: How to get the best response from the forum first.

RE: Documentation for PivotGrid.dll

Dear Gagnon,
I will try to contact them directly.
Thank you for your time Gagnon.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close