Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

SQL Server Reporting Services (SSRS) – How to use an image as the layout of the report and then place conrols on top to display the data

1) On the body of the report, drag a tablix. Make the first row the height and width of your page. Call the Tablix ‘TheTablix’.

2) Drag a rectangle into the first row of the tablix. Call the Tablix ‘TheRectangleRow1’.

3) Left mouse click the rectangle. Click the top left square. Drag the top corner toward the bottom right corner about 3 inches.

4) Left mouse click the body. Right mouse click the body and insert image. Choose Embedded and click import. Click OK. Set the location of the image to 0,0. Change the Sizing to ‘FitProportional’. Call the image, ‘TheImage;.

5) Right mouse click the image, choose layout, and the send backwards.

6) Left mouse click the rectangle. Click the top left square. Drag the top corner back to the top left corner of the body. Copy the size of ‘TheRectangleRow1’

7) In the Properties window, select your image so it is selected. Paste the size of the rectangle size you copied to the clipboard into the size property of the image.

8) If everything was done correctly, when you click within the borders of the page, the image should be selected in the properties window. From here, you can select a control from the toolbox and draw it over the image. The end result, is the control actually becomes a child of the body and that is what you want.

The zOrder shoudld be as follows:

1) The parent of the controls is ‘TheRectangleRow1’.
2) The parent of ‘TheRectangleRow1’ is ‘TheTablix’
3) The parent of ‘TheImage’ is ‘TheRectangleRow1’ but 1 z-order behind the controls.
4) The parent of ‘TheTablix’ is the BODY.

Leave a Reply