DADE Question
If I understand correctly:
In order for the end user designer to work, we have to use the Data
Dictionary. We created the dictionary and created several templates. The
explorer / designer allows the user to select one of our default templates,
make changes and save thier version back to the database.
My question is, when printing one of these reports how do we get the data to
the report? The data dictionary seems great for letting the user define the
layout, but not for restricting the result set as it's different everytime.
Ideally, we'd like to load the saved report, set the pipeline and print it.
However, this isn't working too well.
The only other Idea I've had is to modify the data dictionaries sql at run
time.
Preston
In order for the end user designer to work, we have to use the Data
Dictionary. We created the dictionary and created several templates. The
explorer / designer allows the user to select one of our default templates,
make changes and save thier version back to the database.
My question is, when printing one of these reports how do we get the data to
the report? The data dictionary seems great for letting the user define the
layout, but not for restricting the result set as it's different everytime.
Ideally, we'd like to load the saved report, set the pipeline and print it.
However, this isn't working too well.
The only other Idea I've had is to modify the data dictionaries sql at run
time.
Preston
This discussion has been closed.
Comments
If you would like to limit the data printed out on the report, I would
suggest using AutoSearch to alter the SQL. You can turn any search field in
DADE into an AutoSearch field and allow your users to filter the data they
are going to see as well as limit the data that you want them to see. Take
a look at the AutoSearch demo reports when running the demo app in the
\RBuilder\Demos\3. End User\Report Explorer\... directory.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Is this the only way? Is it possible to get DADE to work off of a
ClientDataSet rather than a query? Ideally, I just want to provide a
pipeline, and let the user design whatever they want using that pipeline.
Keep in mind the pipeline could be a JIT, or hooked to a dataset, or a
client dataset.
Preston
When working with DADE, all pipelines are generally internal and exist
behind the scenes while creating dataviews in the data workspace. It is
possible to link an ordinary datapipeline to a DADE dataview and vice versa.
If you would like to use client datasets with DADE there is a DataSnap
(Midas) demo available that can be downloaded from the following address.
http://www.digital-metaphors.com/tips/RBEndUserWithDataSnap.zip
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com