Adding images to a Visual Studio Report Server Project

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 two 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 (this blog) Bulk uploading images to a report server in SSRS

Bulk uploading images to a report server in SSRS

Part two 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 (this blog)
Bulk uploading images to a report server in SSRS

Posted by Andrew Gould on 04 December 2024

In this blog

The Files to Upload
Creating a Report Server Project
Adding Images to a Project
Adding More Projects

To upload multiple image files to the report server, we'll use Visual Studio to create a report server project, add our image files to the project and then deploy it to the report server.

The Files to Upload

In this example, I'd like to upload multiple image files stored in separate folders in my file system.

Three subfolders in a Windows filesystem

I have three subfolders, each containing multiple images.

I'd like to replicate this set of subfolders when I upload the images to the report server.

Creating a Report Server Project

In Visual Studio, we'll create one report server project for each of the subfolders shown above. To begin, open Visual Studio and choose to create a new project. Here's how to do this in Visual Studio 2022:

Creating a new project in Visual Studio 2022

Open Visual Studio and choose Create a new project.

Next, choose which type of project to create. For this example we'll create a Report Server Project

Creating a report server project in Visual Studio 2022

Select Report Server Project (you can use the search box at the top to filter the list) and then click Next.

Enter a name for the solution and the first project and choose where to save the solution:

Configuring a Report Server project in Visual Studio 2022

The Project name will be used to set the folder name when we deploy the project later.

Click Create to create the solution. After a few seconds you'll see the solution and project listed in the Solution Explorer window:

A new solution and project in Visual Studio 2022

Your new solution and project displayed in Visual Studio.

Adding Images to a Project

To include image files in a project, we need to add them to the Reports folder. To do this, right-click the Reports folder and choose Add | Existing Item...

Adding existing items to a report server project in Visual Studio 2022

Choose the options shown above to start adding files to the project.

You can now choose the image files you want to include in the project:

Choosing image files to add to a report server project in Visual Studio 2022

Choose to view All Files (*.*) from the filter dropdown list, then pick the files you want to import and click Add.

You'll see your selected files appear in the Reports folder of the project:

Imported image files in Visual Studio 2022

The files have been imported into the project.

Adding More Projects

If you want to create multiple folders of image files, you can create multiple projects in the same solution. To do this, from the Visual Studio menu choose File | Add | New Project...

Adding a new project to a Visual Studio 2022 solution

Choose the option shown here to add a project to the existing solution.

You can then choose which type of project to create:

Choosing to add a report server project to a solution in Visual Studio 2022

You should find Report Server Project in the recently used templates list.

Give the project a name which matches the name of the folder you want to create:

Configuring the new report server project in Visual Studio 2022

When we deploy this project, it will create a folder called Countries on the report server.

Click Create to add the new project to the existing solution:

Two report server projects in a Visual Studio 2022 solution.

Your second project will be displayed in the same solution.

You can now add images to the Reports folder of the new project. Repeat this process for each folder you want to create on the report server.

Multiple report server projects in a Visual Studio 2022 solution.

Our solution contains three report server projects, each of which contains a set of image files in the Reports folder.

The next part of this blog series shows you how to configure and deploy your projects to upload all the images to the report server.

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

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

The Files to Upload

Creating a Report Server Project

Adding Images to a Project

Adding More Projects

Head office

London

Manchester