Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Parameters of Query

rbuserrbuser
edited May 2004 in End User
I need to set query params from code (NOTE: not from Delphi, but from the
designer) to "drive" my querys with params of different sources (more
queries, or as result of some calculation).
Now I can write the query manually with params, but I cannot set its params
values from code.
How can I do it?

Thank you in advance,
Cristian

Comments

  • nardmoseleynardmoseley
    edited May 2004

    One option is to use Delphi code and use the Report.Template.OnLoadEnd event
    to extract the TdaSQL object from the dataview and modify the SQL.

    www.digital-metaphors.com/tips/ExtractSQLObject.zip

    Most of the RAP events occur too late, after the report engine has already
    initialized the datasets. The exception is the BeforeAutoSearchDialogCreate
    and OnGetAutoSearchValues events. However these events only fire if
    AutoSearch criteria are present.


    --

    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

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