Microsoft SQL Reporting Services - TechRepublic
Question
June 26, 2009 at 02:26 AM
jeffreyalejo

Microsoft SQL Reporting Services

by jeffreyalejo . Updated 16 years, 8 months ago

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!

This discussion is locked

All Comments