Sorting a frxUserDataSet
I’m working on porting our Delphi app from VCL to FMX so I’m looking at switching from Digital Metaphor’s Report Builder to FastReport but I’m hung up on something that’s probably very simple. All of our data is stored in objects contained in tObjectLists. There are three “databases” so I created 3 frxUserDataSets and they’re working just fine. However, I have two questions about the frxUserDataSets:
1) Report Builder’s equivalent of this component has an OnOpenDataset and a OnCloseDataSet event. These were handy because I was actually populating my tObjectLists when the database was opened (in order to filter records for the report). Is there no event for the opening and closing of the tfrxUserDataSet?
2) (This one is really the bigger issue) I want the user to be able to dictate, within the report editor, which fields will be sorted on. If they could pick the sort fields and I could retrieve their choices from the report before printing it, I could sort my tObjectList before printing the report. In Report Builder, I was able to add a menu item to the designer menu; that menu item brought up a custom dialog in which they could select the sort order. I’m sure I’m just not grasping the premise of how this is done, but I can’t find anything in the documentation about sorting frxUserDataSets