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

Parameterized query

edited August 2005 in End User
?Can we write parameterized query in report builder and how ? Is it
possible to make reports in report explorer using parameterized query at
design time.
Thanx



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • edited August 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.



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


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2005
    ?Can we write parameterized query in report builder 7 and how ? Is it
    possible to make reports in report explorer using parameterized query at
    design time without using auto search dialog box.
    Thanx



    --- posted by geoForum on http://delphi.newswhat.com
  • edited August 2005

    Use the approach suggested in your other thread in the RAP newsgroup. :)

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


    Best regards,

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