Tag Archives: publish report parts from report designer

Deploy SSRS Report Parts From Report Designer with SQL Server Data Tools

Report Parts can be managed in SQL Server Data Tools (previously Business Intelligence Development Studio) through the Report Designer, as well as Report Builder 3.0 (available in SQL Server 2008 R2).

From your SQL Server Data Tools (SSDT) Project, double click your report, go to the Report Menu and Select Publish Report Parts, then select the parts you specifically would like to publish in the current report.

Image

The difference between Report Designer and Report Builder is that Report Builder 3.0 will actually deploy the parts to your Report Server, whereas Report Designer still has an additional step to go.  To finish the job, go to the deployment properties for your SSDT Report Server project, set deployment options for your report parts and deploy the project.

Image

Also, unlike Report Builder, republishing a Report Part from Report Designer has to be made in the report you created the report part.    Whereas Report Builder, allows you to republish an existing part by simply republishing the changes even if you are not in the original report.  An option to ease the management is to maintain all of your report parts in one or more master RDLs.

Images can be saved as stand alone Report Parts or incorporated into existing parts e.g. A report Header Rectangle.  Use External or embedded links to store the image before publishing the part.  If the environment is too complicated for managing External links between development and production environments, consider embedding the image before publishing the part.

Managing the deployment of Report Parts through Visual Studio SSDT will make it easier to deploy report part content between the various environments whether it be development, test or production.