Question Locked
Microsoft SQL Reporting Services
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to have a variable QUERY STRING of a report made from MSRS?
Consider the following:
Report Name: MyReport.rdf
Query String: SELECT LastName, FirstName FROM MyTable
can I set the Query String as a variable like this:
Query String: @VarQuery
wherein @VarQuery = SELECT LastName, FirstName FROM MyTable
Thanks in advance!