Executing different sql queries based on report parameter.

RahulD

Hi All,

I want to execute 2 different sql queries based on 2 different parameter values.

Total parameters in the report are as follow
1) PARAM_SUPERVISOR.
2) PARAM_WORKTYPE.

case 1) select * from PM where
case 2) select * from PM where SUPERVISOR = ? and WORKTYPE = ?


when i provide blank value for SUPERVISOR then query should retrieve all SUPERVISOR records.

when i provide blank value for WORKTYPE then query should retrieve all WORKTYPE records.

Is there any way to do that ??

Please reply as soon as possible.

Any kind of help is appreciated !!

I am currently using BIRT 2.1

mwilliams

Hi RahulD,

You can modify your query text in your dataSet script with:

this.queryText = "select blah from blah where blah = blah"

You can check the parameter values there and use the appropriate query text for each situation.