Thursday, March 22, 2012

Deployment Report Folder

Hi,

I would like to be able to deploy a report to a particular folder in the report server. It seems when I deploy a report it always shows up in the root even after I have moved it into another folder where I wish it to reside.

Thanks,

DD

You set the deployment path of reports (and datasources in 2005) using the project property pages.

Right click on the project (in solution explorer) - select "properties", then if you expand "configuration properties" in the left hand pane of the dialog and select "general"

You can now see the "target report folder" (and if using 2005 "target data source folder")

you can amend this as follows

if you want the following folder

root/adminReports/server

just put

"adminReports/server" in the "target report folder" textbox

|||Right, but that changes the deployment folder for the whole project. I don't seem to be able to change the reports individually. What would be sweet would be if you add folders to your solution and the deployment process puts the reports in the corresponding folders.|||

You have these options:

1) Create 1 solution per folder group that you require, set them to point at the folders you requires

2) Use configuration manager to create different deployment folders, deploy the reports individually once you've picked your target folder using config mgr

3) Use a tool like Reporting Services scripter to generate a deployment script, then edit this (and the winnt folder structure) accordingly - "find in folders" using vs.net is easy enough [http://www.sqldbatips.com/]

|||

Thanks for the valuable tips. I will check out that Linked Report tool.

I ended up creating a project for every folder.

Thanks,

DD

No comments:

Post a Comment