Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Documentation for PivotGrid.dll 1

Status
Not open for further replies.

Rajesh Karunakaran

Programmer
Sep 29, 2016
549
MU
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,
Rajesh
 
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

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads
 
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?

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

Rajesh
 
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
__GRID_FILTER_AREA = 2
__GRID_DATA_AREA   = 3

x = CREATEOBJECT("PivotGrid.PivotGrid")
x.DatabaseTable("totaldata")
x.SetDbcPath("c:\appname\data\")

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)
			
x.ShowReport()

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!

Thanks
Rajesh
 
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 first.
 
Dear Gagnon,
I will try to contact them directly.
Thank you for your time Gagnon.

Rajesh
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top