Hi,

Could you please answer my following question

I have a query with a parameter being passed in. Something like:

select myvalue from mytable where myparam = @param

This query needs to be used multiple times in the report, and the only difference is the value of @param. . There are multiple situations (dozens) where, if I can't use a single dataset  or something similar, then I literally have to have datasets where the only difference is the value of @param. So I would end up with something like:

dataset1: select myvalue from mytable where myparam = 1

dataset2: select myvalue from mytable where myparam = 2

etc, etc.

Is there anyother way that I can do it.

Thanks in advance

Pri

The thing is the report that I developed has atleast 12 datasets. When I move the report to other databases, datasource changes for them, so I literally have to change the datasource for each dataset everytime I move the report in to other phases like QA, Staging or Production databases.

Do you think if there is anyway that I can use configuration settings or something, istead of changing all the datasets everytime I move the report.

Thanks,

Pri