How to Specify a search option

rbuser

I am using the Report explorer in my program for the End User to save and
load reports that they create.
Is it possible to have a Report called 'Accounts in a specified area' (lets
say 'North') which would print only accounts that are in the area that the
user specifies ?
I know the end user could do this by specifying the 'Area = North' in the
sort option on the Data tab, but is it possible to bring up a little dialog
which asks the user to put in the area value when they click on the Print
Preview or Print button ?
This would mean that they won't have to go into the data tab at all.

Thanks
John

digitalmetaphors

If you are using the Enterprise version of ReportBuilder, it is possible to
do this with AutoSearch option available to the EndUser on the Calc tab of
the designer. Otherwise, you can implement AutoSearch in Delphi and manually
inject the chosen parameters into the SQL statement. See
RBuilder\Demos\AutoSearch\AutoSearchFieldToSQLParams for an example.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

I've had a look at the demo you suggested and that will work fine with some
reports.
The problem i have is with the Reports that i will have in the Report
Explorer.
I would like the users to select a Report from the Report Explorer (Maybe a
Report called 'Accounts by Region', then when they go to open the report (or
to Print it), i would like a Dialog to come up asking them to enter which
Region they would like to search on.
I know this can be done by going into the Data Tab and setting up the Search
that way, but it is not very intuitive.
Could i do the above with Report Builder ?
Thanks for your answers
John


"Alexander Kramnik (Digital Metaphors)" wrote

digitalmetaphors

AutoSearch through DADE (the Data Tab) which is part of ReportBuilder is the
most comprehensive solution available for specifying search options. Setting
up AutoSearch criteria would allow your users to accomplish exactly what you
describe below, that is present your users with a criteria dialog when the
open a report.

--
Cheers,

Alexander Kramnik
Digital Metaphors