Bulk uploading images to a report server in SSRS

This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Bulk uploading images to a report server in SSRS Part three of a three-part series of blogs
In SQL Server Reporting Services, storing images on a report server provides a convenient way to display pictures in a report. Uploading images one-by-one is tedious so this blog shows you one way to upload multiple images at the same time, including how to organise the files into different folders. Uploading single files in the SSRS web portal Adding images to a Visual Studio Report Server Project Bulk uploading images to a report server in SSRS (this blog)

Bulk uploading images to a report server in SSRS

Part three of a three-part series of blogs

In SQL Server Reporting Services, storing images on a report server provides a convenient way to display pictures in a report. Uploading images one-by-one is tedious so this blog shows you one way to upload multiple images at the same time, including how to organise the files into different folders.

Uploading single files in the SSRS web portal
Adding images to a Visual Studio Report Server Project
Bulk uploading images to a report server in SSRS (this blog)

Posted by Andrew Gould on 04 December 2024

In this blog

Setting the Target Server and Folder
Deploying the Solution
Checking the Results

Now that we've added all the images to projects in Visual Studio we need to deploy the projects to upload the files to the report server.

Setting the Target Server and Folder

Each project in the solution needs to know the URL of the report server and the folder to copy its files to. To set these properties, start by right-clicking a project and choose to view its properties:

Choosing to view project properties in Visual Studio 2022

I'm choosing to view the Properties of the Certificates project.

In the dialog box which appears, enter the path of the folder you want to upload the project's images to. The default name will match the name of the project, but you can change this if you like.

Setting the target folder for a report server project in Visual Studio 2022

Set the TargetReportFolder property to the path of the folders you want to create for this project.

Enter the URL of the report server in the TargetServerURL property. The value you enter will depend on the configuration of your report server. Click OK when you've done this.

Repeat this process for each of the other projects in the solution:

Setting the TargetReportFolder property for a report server project in Visual Studio 2022

These are the properties I've applied to the Countries project.

Deploying the Solution

The final step is to deploy the solution to copy each project and its files to the report server. To do this, right-click the solution and choose Deploy Solution.

Deploying a solution in Visual Studio 2022

Select this option to begin copying files to the report server.

You can see the progress of the deployment in the Output window:

The Output window when deploying a report server project in Visual Studio 2022

Things are looking good so far!

Checking the Results

To check that your files have been deployed correctly, navigate to the Reporting Services web portal and refresh the page.

A new folder in the reporting services web portal

A new folder has appeared in the web portal.

You can click on a folder to see its contents:

Subfolders in the Reporting Services web portal

Clicking the Images folder reveals a subfolder for each project we deployed.

Finally, clicking on a subfolder will reveal the images it contains:

A list of image files stored on a report server

Every image in the project has been uploaded.

You can now reference the uploaded image files in your SSRS reports.

Parts of this blog
Uploading single files in the SSRS web portal Adding images to a Visual Studio Report Server Project Bulk uploading images to a report server in SSRS (this blog)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post