AutoSearch Parameters issues

rbuser

Hi, All,

I find that the rtm files about autosearch parameters (in
\RBServer\Demos\Servers\04. Custom Parameters\Report Files) don't need any
extra events to get the search form. But when I create a new report, if I
want to get the search form, I need to write codes to create some
AutoSearchFields in OnBeforeAutoSearchDialogCreate and OnGetAutoSearchValues
events. Anybody can tell me what's the trick. Thanks a lot.

Michael

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.

rbuser

Thanks a lot.

I got two more questions about Data workspace of the Report Designer.
1.Can I use subquery in Data workspace? For example, If I create two
DataView, can I use one of them as a table?
2.It seems that I can't modify the sql statement. But if the query is
complex, how to populate the sql statement?

Thanks again.

Michael

nardmoseley

This is covered in the Learning ReportBuilder Guide that can be downloaded
from our web site.


The Designer can be configured to allow the manual editing of SQL Text. Once
you manually edit the SQL text the linking and autosearch features will no
longer be supported by the dataview.

For future reference, please post DADE related questions to the DADE
newsgroup.