Change SQL on the Server

rbuser

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

nardmoseley

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