SSRS Deployment

Question

SSRS Deployment

muniappank

SSC Journeyman

Points: 85
More actions
December 17, 2007 at 10:07 am

#182140

I created the sql server reports and data sources. Each reporting is using 2 data sources. In the same server I want to deploy reports for multiple clients. The deployment path should be ClientName\Data sourcename\[data sources] and ClientName\ReportGroupName\[reports]. Now I am manually deploying reports using target folder etc... I have to manually change targer server, target folder etc... every time I am deploying reports. I want to automate this process. I want the tool to deploy reports based on the configuration file settings. I need the tool ro an idea of how to make it?
Please reply ASAP.
I would like to use RS Build for this purpose. I tried it, It is working fine. But I need to configure 2 data sources for each report. RS Build(rsbuild.config) is allowing me to configure only one data source for the report. I aksed them in the code plex website. But I am not getting any reply regarding this. Please reply me back, If any bodies used it in your project.
Thanks,
Muniappan Kandasamy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

maddogs SSCrazy Points: 2474 More actions · Answer 1

I'm sure you have your reasons why you want to put the data sources into a different target folder on the SSRS server than the reports, but as an alternative IF you were willing to keep them in the same target folder in the format of ClientName\ReportGroupName\[reports & datasources] you could accomplish what you are tryig to do no matter how many data sources you have, most of the way using different project configurations when deploying from Visual Studio.

In Visual Studio, on the report project solution explorer right-click on the report project name and then click 'Properties'. You will then see the configuration settings for the project i.e. what the target folder and server URL is. What you can do is set up a different configuration with corresponding target folder and target server URL for each client - you would name the configuration with the client identification accordingly. At deployment time you can just switch between the configurations quickly to deploy to the different client targets. You would want to customize a toolbar to show the project configuration selection dropdown to make this even quicker. This works for only one client at a time obviously, if you want to deploy to all client targets simultaneously you'll have to use another method.

In case you aren't familiar with creating configurations, from the project properties\configuration window you can click the 'Configuration Manager' button at the top right, locate the report project in the 'Project Contexts' area, then select the 'New... ' option from the dropdown beneath the 'Configuration' column.

Good luck!

maddog

muniappank SSC Journeyman Points: 85 More actions · Answer 2

I would like to use RS Build tool(http://www.codeplex.com/RSBuild) for this purpose. I tried it, It is working fine. But I need to configure 2 data sources for each report. RS Build(rsbuild.config) is allowing me to configure only one data source for the report. I aksed them in the code plex website. But I am not getting any reply regarding this. Please reply me back, If any bodies used it in your project.

tletlalo Valued Member Points: 55 More actions · Answer 3

[font="Verdana"]

Hi, i would like to use this deployment process and i see you are already using it.may you please tell me detailed information on how to use it.

Thanks in advance.

Tebogo

[/font]

sandy1234 Say Hey Kid Points: 673 More actions · Answer 4

Could you tell me way hiw to register the dll files.

i tried to add the dll files in cmd prompt, but it showing some error like dll filecannot be added.