January 14, 2008 at 3:23 am
Hi!
I built a report on a local Server. Now, i want to send this report to another server (same conf. tables etc.) to use is it on it.
How, can i do this?
Thanks
Chris
January 14, 2008 at 3:59 am
Its not clear from your post exactly what you want.
To run a report against another server you can just alter the data source.
If you want to put the report on another instance of reporting services on another server just take a copy of the .rdl file copy it to the new server and add it to the reports.
If you want to run the results to a different server use the rs.exe executable. See http://msdn2.microsoft.com/en-us/library/aa256616(SQL.80).aspx
January 15, 2008 at 8:16 am
I'm going to guess that you developed a report on your local machine and published it using BIDS. IF that's the case, then you have a couple of options...
1) Configure Deployment options in BIDS to allow publishing to alternate environments. By right-clicking your project and selecting "Properties", you can modify the deployment options for your reports. Better still, you can use the Configuration Manager to create multiple targets (e.g. Development, QA, User Testing, and Production), each with their own deployment targets.
2) Your other option is to upload the rdl file manually and configure its datasource. As a general rule, I prefer this option. I've worked on projects both large and small, and in most cases, I prefer to deploy my solutions outside of Visual Studio (or BI Development Studio). It affords me more control and allows me to assemble my "builds" and put them in a location others can access and deploy without a Visual Studio license. For more information on working/managing SSRS, take a few moments to complete the MSDN Virtual Lab. You'll be glad you did...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply