Click here to Skip to main content
15,907,392 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Friends,
I am using VS 2013 and SSRS 2012
I need to implement web application with ssrs reports for live and test purpose
we have two website folder in application server .one for live and one for test
Both folder has different webconfig .one connect to live database .one connect to test database.
It has 2 different database in database server.
I have to Configure SSRS report to both live and test purpose.
How to configure this?

Thanks in advance
George

What I have tried:

I have tried to create different web service urls in same report server instance
Posted
Updated 26-Jul-17 5:41am

1 solution

Normally I do a dedicated test and production instance but I think the way you could approach this in one instance is the following:

1) Create a test and live folder in SSRS
2) Add a folder called DataSources under each test and live folder
3) Then create a TestDataSource and a LiveDataSource (or whatever you want to call it).
4) This way you'd set your TestDataSource to the test DB server and your LiveDataSource to your live DB
5) Then you'll duplicate your reports under both the test/live directories
6) When setting up a report under test directory you'd set your data source to your TestDataSource and then setting up a report under live directory you'd set up the data source for that report to be LiveDataSource.


I would caution against this as if you are using a 1 SSRS server for both test/production purposes. You may bog down your production environment with test server activity. My preference is to physically separate the environments all together but the above is one option/approach to have 1 ssrs server function for both environments.
 
Share this answer
 
Comments
george@84 27-Jul-17 2:57am    
But I am using shared datasource connection which is used in all ssrs reports
David_Wimbley 27-Jul-17 11:31am    
Yes but re-read the solution.

What I am saying is you'll either need to have separate environments, 1 for production/live, 1 for test. In that scenario each env gets its own data source and own set of reports.

Or, you have two data sources on 1 server, label them test and live. Then you'll have 2 folders on there as well to house your reports. It will look something like /live/MyReport1, /test/MyReport1. Then /test/MyReport1 will have the data source of "test" and /live/MyReport1 will have the data source "live".

As far as I am aware, you cannot have 1 report tied to two data sources and switch them dynamically. What i've outlined above are at least 2 approaches to solve your problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900