Hi,

I'm looking for an ActiveX control I can drop on my form to display data in a cross-tabbed format. I need to display more than the 3 fields involved in the cross-tab.

The data structure is Stocks.dbf (parent)
Transactions.dbf (child)
estgrowth.dbf (child - transactions)
One stock has many transactions, one transaction has several growth estimates (one record for each year they are available)

This is how I would like to display the data. The number of date columns expands as new forcasts are made for future years.

Stock.symbol, trans.date, trans.signal, estg.1998, estg.1999, estg.2000, estg.2001, estg...

I've looked into DynamiCube and am considering it. I was just wondering if there is anything else?

TIA,
Jacci