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

Change SQL on the Server

edited September 2004 in Server
Hi,

I would like to change the SQL on the server depending on the Report- or
SessionParameters that are given from the client.

I was thinking about the following two possibilities on how to achieve this:
1. Using a rsReportExplorerVolume event, like BeforePublish report, but
how can I access and modify the query?
2. Change the SQL in the modified daMidas I'm using, but how can I
access the Report- or SessionParameters?

Does anyone know how to solve (one of) these problems, or have other ideas
on how to change the SQL on the server depending on the Report- or
SessionParameters,

Greetings,
Ranjii

Comments

  • edited September 2004

    Use rsReportExplorerVolume.BeforePublish event.

    You can access the parameters using the aEventParams object that is passed
    to the event. To modify the SQL, you need to extract the TdaSQL object. Here
    is an example of modify the TdaSQL object

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

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



    Best regards,

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