I am using MS Reporting Services 2000 and creating my MS Reporting Services Reports in Visual Studio 2003. When setting my SQL query string I can use Select Statements like the following no problem:
- Select RegHrs, OTHrs FROM JOBCLASS WHERE (PayDate >= @StartDate)
* StartDate is user defined parameter that I send from a web page.
What I would like to have the ability to do is a Select Statement Like the Following:
- Select RegHrs, OTHrs FROM JOBCLASS @wherestr
* wherestr would be a user defined parameter representing the where clause part of the previous example
Am I able to accomplish this with MS Reporting Services 2000 ? Is so, how. Any help will be greatly appreciated.