October 2, 2006 at 10:53 pm
Hello all,
The company I am working with hosts many web sites. Each site has a folder defined in reporting services. Presently we create a folder for each site, then create a data source for each web site (client). Each web site has it's own SQL database to report against.
There are a couple cumbersome tasks I wanted to know if there is an easy way to speed up since I have to do this on a regular basis.
First - I have to manually import 29 RDL files and load them in one at a time with the web page - that is painful in itself.
Second, after I load in all the 29 RDL files, I have to go back into each report and define the data source. This is the most painful part. Is there a way to tell all the reports in a folder to use the same data source?
I am running RS 2000 and SQL 2000.
Any help would be much appreciated!!
October 3, 2006 at 5:11 am
If you're deploying through Visual Studio can you not just change the destination folder on the reportserver for the reports and data source for each client?
October 4, 2006 at 3:54 pm
My sugggestions below:
1. I think that you might be able to use a free app supplied by MS to do what you want take a look at this link. You can use the RS.exe utility to import files to specific dirs...
http://www.sqldbatips.com/showarticle.asp?ID=62
2. If the reports all access the same db and they are in the same VS project then setup your datasource as 'shared'.
When you publish the data source for the first time you'll have to change the server and db details for your live site presumably, but as long as you have the overwrite data source setting turned off then the data source will stay there unchanged.
Then when you deploy the reports they will pick up your report server data source automatically.
Martin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply