Configure DB connections in SSRS reports
Hi, Is there a way to configure the DB conenctions in SSRS, like the way we do in SSIS. I am asking this, to take care of moving the code from development to production server,without manually changing the connection.
October 11th, 2010 9:05am
Do you mean like a config file? You can supply parameters for the data source , server name, db name and etc.Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
October 11th, 2010 9:09am
Can you give me a brief descriptions of how to achieve this?
October 11th, 2010 9:40am
Here you go http://www.sqlservercentral.com/articles/Development/2945/Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
October 11th, 2010 9:50am
Hi Uri, Thanks for the link.But if I do this, I have to manually set the Report parameters, once I move the code to the production server. I dont want to do that. Have I missed something in my understanding?
October 13th, 2010 2:28pm
As far as I know, there is no way to do what you want in SSRS. I'm guessing you want something similar to the SSIS configuration files or variable parameters that you can pass in. The closest you will come to this is building the actual URL yourself and passing the values to populate parameters. It would be seamless to the user at that point. The possibility still hangs over the report that the user may go to the page without the values and have to select them. When it comes to reporting, I do not like to make transports like you need seamless however. Using shared data sources and changing them via report manager once a report is approved from dev-->uat-->production is a great way to ensure you are solid on where the report is requesting data. It is, if you will, an added security that the report has been reviewed, code, functionality etc..before putting it live. Ted Krueger Blog on lessthandot.com @onpnt on twitter
October 13th, 2010 3:13pm
Hi Ted, Thanks for your response. Your understanding of my requirement is correct. I am going to try your suggestion and will update you.
October 13th, 2010 7:14pm