Wednesday, March 7, 2012

Pass report parameters to data source (2000)?

In the data tab of my report (Reporting Services for SQL Server 2000), I'd like to run a query that requires parameters be passed to it. Is there a way to pass the parameters of the report to that query?

Thank you.

Hello,

Yes, of course you can. Let's say you have a parameter named Param1, in the data tab, your query would look something like this:

select * from table1 where field2 = @.Param1

Hope this helps.

Jarret

|||I knew it had to be simple... Thank you so much! Smile

No comments:

Post a Comment