TfrxUserDataSet and TCollection

martinrame

Hi, I'm trying to automatically generate a report using data provided by a TCollection.

TCollections are composed by TCollectionItems, wich also contains both native data types and TCollections in its published fields. An example is:

TEmployees (TCollection)
TEmployee(TCollectionItem)
TSalesByEmployee(TCollection)

So, I want to create a report listing all employees and all the sales by each employee. I can't access directly to the database. Because of that, I created a report containing a MasterData bound to a TFrxUserDataSet for listing employees, and a DetailData bound to another TfrxUserDataSet to list the sales by employee.

Can anybody help me?

Leonardo.

gordk

I havent tried using a tcollection to supply data to an frxuserdataset.
but for sure you will need to write code for each of the events of the frxuserdatasets to control movement in the dataset.
onfirst, on next, on prior, and on eof.
and ranges props as well.

martinrame

Yes, thanks Gord.

I'm reaching a solution for this. If I can make this abstract enough to be used with any TCollection descendant I'll share the solution with you.

Sincerely,
Leonardo M. Ram?©

gordk wrote: »

I havent tried using a tcollection to supply data to an frxuserdataset.
but for sure you will need to write code for each of the events of the frxuserdatasets to control movement in the dataset.
onfirst, on next, on prior, and on eof.
and ranges props as well.