Change deployment location of SSRS Report and subreports, then link subreports to main report.

Dale Fye
Dale Fye used Ask the Experts™
on
1.  I need to change the destination of an SSRS report in Visual Studio 2010 so that when I deploy it, it goes to the correct folder.  There appear to be about 6 or 10 places where I can change options, I just cannot seem to find the right place to change these deployment options.

2.  On this particular report, there are two subreports.  I would like to deploy these two reports to a separate (subfolder) under the folder which contains the main report.  I assume that the changes I make in #1 are for SSRS, not for a particular report (is that correct).  If so, I will need to change the path for those subreports as well.  How do I change the path to these subreports in the Visual Studio report designer?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
As far as I'm aware that should be done easily from the Project under Project Properties where you need to change the Deployment/Release  path "OutputPath" (where the .rdl file will be located) as described here https://docs.microsoft.com/en-us/sql/reporting-services/tools/set-deployment-properties-reporting-services?view=sql-server-2017
As far as #2 item goes it looks like VS and SSDT for that matter - does not let you do this easily and one solution would be  to make sure the Subreport is in your project, then you use the dropdown to select the report. When development is complete, the Main report needs to be changed to reference the correct folder (/Sub reports/myReport.rdl) and the Subreport needs to be deployed to the correct folder (/Sub reports). This means there will be 2 copies of the sub report-- 1 in your MainReport project, and 1 in your SubReport project. Not ideal that there's two copies to keep up-to-date, but I think this works.
Better option for #2 on your list may be to add a symbolic link to your projects folder\bin\debug\full\subreport\path as nicely done here:
http://www.andrewmosey.com/subreport-in-a-sub-folder-working-in-visual-studio-and-ssrs
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Author

Commented:
Thanks, Icohan!  Those two links provided just the info I needed.

Dale

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial