FR4 in a multi-tier environment
FR4 / D2009
Most of our apps are multi-tier applications... meaning they are either using Datasnap with HTTP to get data down to a local ClientDataSet or using RemObjects Data Abstract product to get data down into a local DAMemDataTable. The end result is the data is pulled down to a local dataset. The application then works with the data and if changes are made they apply updates which are then sent back to the server as deltas (changed data).
Now for reporting we don't change the data so all we do is pull it down to the local datasets. In the past using ACE Reporter we simply tied to these datasets.
I know with FR4 I can use these same datasets and link to them via the frxDBDataset.
So my question... is there a way to deal with multi-tier environments withing the report itself so that I can encapsulate the data in the report even when running the report outside of Delphi? I don't think there is since I can't put the components required for multitier in the report itself, but I was wondering what others were doing?
I really wanted to give a shot to keeping the data inside the report so changing the report could be done without recompiling, but I don't see how we can avoid this in a multi-tier development environment.
Thoughts?
Thanks in advance,
Greg
Most of our apps are multi-tier applications... meaning they are either using Datasnap with HTTP to get data down to a local ClientDataSet or using RemObjects Data Abstract product to get data down into a local DAMemDataTable. The end result is the data is pulled down to a local dataset. The application then works with the data and if changes are made they apply updates which are then sent back to the server as deltas (changed data).
Now for reporting we don't change the data so all we do is pull it down to the local datasets. In the past using ACE Reporter we simply tied to these datasets.
I know with FR4 I can use these same datasets and link to them via the frxDBDataset.
So my question... is there a way to deal with multi-tier environments withing the report itself so that I can encapsulate the data in the report even when running the report outside of Delphi? I don't think there is since I can't put the components required for multitier in the report itself, but I was wondering what others were doing?
I really wanted to give a shot to keeping the data inside the report so changing the report could be done without recompiling, but I don't see how we can avoid this in a multi-tier development environment.
Thoughts?
Thanks in advance,
Greg