Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 [SOLVED] - Setting Variables in a report

Author  Topic 

Starting Member

1 Post

Posted - 2015-04-10 : 05:52:03
I am currently using MS Access to run a query which requests a variable each time it is run.

I want to do the same thing within SQL Reporting Services. Although new to SQL I am aware how to declare a variable within a query. The only problem is I have to change the variable each time the query is run and this does not look very good.

Can anyone advise a way of declaring a variable in a text box when the report is run. A you tube link or instructions would be really helpful.

Many thanks


Mark A

- Advertisement -