End-User Reporting with Search Criteria at Runtime

rbuser

Is it possible within the end-user report generation/use capability to build
reports that have search parameters defined at run time? In other words, is
there a method of getting Explorer/Designer to prompt for the values to
determine selection for inclusion in the report?

The reason for this is that some more sophisticated users will create
reports that will be used by others without the skills to modify the
report/SQL at run time. Another reason is that reports can be used for
variable data sets.

Regards,
Tom

nardmoseley

----------------------------------------------------
Tech Tips: Creating AutoSearch parameters via DADE
----------------------------------------------------


1. Access the Data workspace of the Report Designer.

2. Create a DataView using the Query Wizard or Query Designer.

2. A DataView tool window will be displayed in the data workspace.

3. Press the Search button. The Search tab of the Query Designer will be
displayed.

4. Add a search criteria item and select the AutoSearch checkbox. You can
optionally select Mandatory as desired.

5. Close the query designer.

6. Now when you select the Preview tab of the Report Designer. A search
button will appear on the toolbar. This displays the AutoSearch dialog.

7. By calling Report.Print in code, or by selecting print/preview from the
report explorer the AutoSearch dialog will be automatically be displayed.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thank you. I had missed this tip. Works great!

Tom