End User Queries
Greetings again all -
Here is my situation. We have created ReportBuilder as a standalone
support program for our customers to generate their own reports from our
databases. Everything is fine from that point - I can easily walk
customers through generating queries in data, and turning on
"AutoSearch" for selecting dates and what not.
The problem is when I need 2 or more queries to have the same date
range. Right now, the only way I am able to do it have all the queries
ask for a date range (so the user has to enter 1/1/2006 - 12/31/2006
multiple times.
How can I ask for the date once, and apply it to the other queries
generated in report builder.
(Note: I can easily do this in Delphi w/ Report Builder - but it doesn't
solve the problem of showing customers how to do this in RB so they can
do their own custom reports.)
Also - we are using 10.03 (I believe, or .04) of Report Builder.
Thanks in Advance -
Chris Kiraly
PS: Also, if this is able to be done, does it require programming
changes on our end in report builder (as far as building the executable
for release) or is it just how you can set stuff up in the "Calc" tab
inside ReportBuilder.
Here is my situation. We have created ReportBuilder as a standalone
support program for our customers to generate their own reports from our
databases. Everything is fine from that point - I can easily walk
customers through generating queries in data, and turning on
"AutoSearch" for selecting dates and what not.
The problem is when I need 2 or more queries to have the same date
range. Right now, the only way I am able to do it have all the queries
ask for a date range (so the user has to enter 1/1/2006 - 12/31/2006
multiple times.
How can I ask for the date once, and apply it to the other queries
generated in report builder.
(Note: I can easily do this in Delphi w/ Report Builder - but it doesn't
solve the problem of showing customers how to do this in RB so they can
do their own custom reports.)
Also - we are using 10.03 (I believe, or .04) of Report Builder.
Thanks in Advance -
Chris Kiraly
PS: Also, if this is able to be done, does it require programming
changes on our end in report builder (as far as building the executable
for release) or is it just how you can set stuff up in the "Calc" tab
inside ReportBuilder.
This discussion has been closed.
Comments
There is no built-in feature that will allow your users to do this. One
option would be to use RAP as you would in Delphi and assign the autosearch
value entered to all your datasets using the TdaSQLBuilder object. The only
other option would be to enter the autosearch criteria for each dataset as
you mentioned below.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Can you give me a quick sample of how you would do this in RAP?
Take a look at the TdaSQLBuilder topic in the RBuilder help. This gives you
a number of code examples on how to use it to manually create and add search
criteria to your datasets in DADE from Delphi code or from RAP. You would
most likely want to use the OnGetAutoSearchValues event of the TppReport to
get the value entered by your user and assign it to the search criteria of
your other queries.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com