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

Passing a GROUP statement in SQL

edited March 2002 in RAP
Hi,

Depending on a user's choice (custom UI) I might want to modify a report's
SQL statement to include a GROUP statement. How is this possible at
run-time?

RB 6.03

Regards

Comments

  • edited March 2004


    Why are you posting 3/16/2002? Today is 3/16/2004.
    Please correct the date on your machine.

    RAP is designed to enable the developer and end-user to perform calculations
    and dynamically control report elements while the report is generating.
    Except for a couple of the AutoSearch related events such as
    BeforeAutoSearchDialogCreate and OnGetAutoSearchValues, the events in RAP
    fire after the report engine is initialized, which is too late to modify the
    SQL.

    The AutoSearch related events described above only fire in the case in which
    AutoSearch fields have been defined for the report.

    If you are using the ReportExplorer to load the templates from the database,
    you might try using the Report.Template.OnLoadEnd event to initialize the
    SQL. This event fires when the report is loaded from the database. For an
    example of using this event, see RBuilder\Demos\EndUser\ReportExplorer.

    This example shows how to extract the TdaSQL object from a TdaQueryDataView
    and modify it.

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





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

    Best regards,

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