Reporting Services - Deployment and Global / General Configuration Between Reports

Question

Can I add global variables that are distributed between reports in SQL Server Reporting Services? I know that you can add variables to a report, but I want the same variables to be used from different reports.

In addition, is it possible to have different configurations for different servers so that they use different settings when deploying reports? (e.g. web.config for SSRS reports). The goal is to have different settings for the development, testing and production environment. As of now, I need to change the variables in the report properties before deploying.

(of course, it is possible to create a table in the database for the report parameters, but I really do not want to spoil the supplier databases or add new databases only to add a global report configuration)

Answer 1

You might want to explore custom assemblies http://www.code-magazine.com/article.aspx?quickid=0701061&page=2

Answer 2

I personally use the parameters to assign the code, but you can define them in the web interface.

- http://127.0.0.1:80/ReportServer/, , get url, & param1 = toto & param2 = 1986 -09-29 12: 30 & param3 = 1

, connectstring .

RssScripter http://www.sqldbatips.com/showarticle.asp?ID=62 script .

,