A common wish in SQL Server Reporting is to create an image with a text inside the image. When you are a common user of SSRS, you know this is not so easy. You cannot simply insert an image and a text on top of it. Your layout will be a mess because you cannot place object over each other.
I am using images a lot in SSRS. It’s a good way to visualize data. It’s very powerful when you use it together with text or a graph. I like to use it in SSRS Dashboards to create some kind of infographics like objects in reporting services. The trick to get the text inside an image in SSRS is very easy.
The first step is to create a rectangle to the report. You need to do this because you will set the image as a background image.
The next step is to add an image to your visual studio project. Right click on the shared dataset folder or the Reports folder within your project and click “Existing Item.. “. Then, click on “all items on the right an select the image on your computer you want to use in your report.

Click on the rectangle and press F4, the properties windows will occur on the right of your screen. Select “BackgroundImage”, Source: External. Then select the image you added to your project. Set BackGroundRepeat to “Clip”


No you have added the background image to the rectangle. Maybe it’s too large or too small, you need to play with it. You are now able to put any kind of object in the rectangle without loosing your layout. In my example, I have added the Dutch Map as a background and market share as a value. This looks really cool.
Results:

Frequently asked questions
How do I put text on top of an image in SSRS?
Add a rectangle to the report and set the image as its BackgroundImage. Then place text boxes inside the rectangle. This way the objects do not overlap on the report canvas and the layout stays intact.
Why can I not place a text box over an image in SSRS?
SSRS does not let you place objects over each other. Your layout becomes a mess. A rectangle with a background image avoids this, because it can hold other objects.
How do I set a background image on a rectangle in SSRS?
Add the image to your project with Existing Item. Select the rectangle and press F4. Set BackgroundImage to Source: External and choose the image. Set BackGroundRepeat to Clip.
What does BackGroundRepeat Clip do in SSRS?
Set BackGroundRepeat to Clip on the rectangle that holds the background image. If the image is too large or too small, you need to play with its size.
What can I build with an image and text in SSRS dashboards?
Infographic-like objects. The example uses a map of the Netherlands as the background image and shows the market share as a value on top of it.
1 comment
Great explanation and thus far the best solution. Just needs a bit of tweaking but it works.
Related blogs
T-TSQL - Create 4 week Moving Total
SSRS2008R2 - Keep Header Visible While Scrolling
Wrong dot and comma in SSRS