Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

AutoSearch Parameters issues

edited November 2005 in Server
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

Comments

  • edited November 2005

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





    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited November 2005
    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


  • edited November 2005


    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.

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.