I use Dynamicube and have found it invaluable for making complicated data look simple. I have even been able to combine "Query By Form" with Dynamicube to create a pretty slick financial report writer for my end users. I even allow them to save their queries for re-use and even specify the colors of the grid.

Just a note, the next version of Dynamicube (called ActiveCube) only supports Microsoft OLAP data sources. Interestingly enough, the "pivot table" in Excel 2002 (part of Office XP) looks almost EXACTLY like the current version of Dynamicube and it supports more aggregate functions. It's just not easy to package and royalty-free like Dynamicube.

Here is an example using the Click() event of how to retrieve:
the Row Heading
the Column Heading
the Data Value

*** ActiveX Control Event ***
WITH THISFORM
&& Retrieve the Hotel Name
.zoRowHeading1 = This.RowHeading(This.SelStartRow,1)
If !Isnull(.zoRowHeading1)
.txtRoom_Type.Value= alltrim(.zoRowHeading1.caption)
Endif

.zoColHeading1 = This.ColHeading(This.SelStartCol,1)
If !Isnull(.zoColHeading1)
.txt_Date.Value = CTOD(ALLTRIM(.zoColHeading1.Caption))
Endif

.txtNbr_Room.value=INT(This.DataValue(This.SelEndRow,This.SelStartCol))
ENDWITH

Good luck!

Paul James
Life-Cycle Technologies, Inc.
Flowery Branch, GA