Unidirectional DB?
I will be converting from Paradox/BDE to SQLite database(Delphi XE2,RB
14.05). My project now has many RB reports created simply by dropping a
ppReport and a ppBDEPipeline on a form and dropping data fields etc. on
the form.
1. I read somewhere that the "usual way" does not work with
unidirectional datasets. What are the steps to make it work? Any
examples or documents? Can I use TSimpleDataSet or do I need to use
TCLientDataSet in Delphi? Use JIT pipeline or DB pipeline?
2. I have many end-user reports which are saved and emailed back and
forth, allowing end users the opportunity to modify or design their own
new reports. Any special issues for them accessing the data in the
unidirectional dataset?
TIA,
Scott Stalheim
14.05). My project now has many RB reports created simply by dropping a
ppReport and a ppBDEPipeline on a form and dropping data fields etc. on
the form.
1. I read somewhere that the "usual way" does not work with
unidirectional datasets. What are the steps to make it work? Any
examples or documents? Can I use TSimpleDataSet or do I need to use
TCLientDataSet in Delphi? Use JIT pipeline or DB pipeline?
2. I have many end-user reports which are saved and emailed back and
forth, allowing end users the opportunity to modify or design their own
new reports. Any special issues for them accessing the data in the
unidirectional dataset?
TIA,
Scott Stalheim
This discussion has been closed.
Comments
You are correct, unidirectional datasets are not directly supported with
ReportBuilder.
You will need to use a client dataset or another in-memory dataset to
traverse the unidirectional dataset first, then connect that dataset up
to the report datapipeline.
As long as you have separated the unidirectional datasets from
ReportBuilder there should be no problem allowing your users to
edit/create their own reports.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com