August 9, 2010 at 4:15 pm
Hi,
We have SQL Server 2005 reporting services and have one Oracle datasource.
We have given the URL name http://servername/reportserver to connect to ReportServer with Oracle datasource 1 and view the reports from application.
Now we want to create another Oracle database and use the same reprotserver instance and deploy the reports for another application?
Is that possible?
Lets say,in Report manager, REPORTSDEV folder and DATASOURCE folder are created
10 reports are deployed inside REPORTSDEV folder and Oracle datasource1 is created.
Application is calling this reportserver url using http://reportserver/reportserver
Now we want to create a folder REPORTSQA and Oracle datasource datasource2 and deploy 10 more reports. Then how the same application can point to this reportserver url?
DO we need to use http://servername/reportserver or how that works?
Thanks
August 9, 2010 at 10:39 pm
First of all the .RDL files you create using BIDS or Report Model use the DataSource Property....you may want to have a look at the RDL file once.
So, go ahead create as many reports you wish and deploy them to the report server.
It will all work as a charm :-):-):-)
Raunak J
August 10, 2010 at 7:08 am
You can use many different data sources. However the way your BIDS project is configured will determine when the data sources are deployed. If you 2 different sources and you name them the same thing, you will run into problems unless you place them into separate folders. By default BIDS will not overwrite an existing data source, but will deploy a new data source.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply