Parameterized SQL in reports

rbuser

Hi!

I created some pipeline in report designer, not on application form. Is it
possible to parameterize this pipeline like I can do it with the pipline on
the application form?

Thank you.

nicocizik

Hi Maxim,

Instead of parameters, you have the ability to change the search criteria in
DADE using the AutoSearch capibility. Using autosearch, you will be able to
pass in new search criteria to your query as it runs or define the criteria
on the fly before the report is printed. Check out the Autosearch demos
located in the \RBuilder\Demos\Autosearch\... directory. See the article
below for more information.

----------------------------------------------------
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.

--