Images in SSRS reports

RoyB09 306 Reputation points
2020-09-22T16:14:13.133+00:00

Hello

I’ve got a report where I'm using rectangle to create a page. I've dragged an image onto the rectangle and resized the image the same as the rectangle.
The image has the rectangle as it’s parent. I’ve added text boxes on top of the image, the text box has the rectangle as it’s parent.

My issue is the text box is not appearing when I Preview the report, but it does appear when I export the report to PowerPoint. I’ve found a number of possible solutions on-line, send the image and rectangle to Back and text box to Front, set the Can grow property to False etc. but nothing is working.

I then set the background image of the rectangle to the image I needed. The text boxes did appear but not the entire image. I then tried all the Background Repeat options, but couldn’t get the image to fit the rectangle. It’s got a logo in the bottom center, but I just couldn’t get it to fit. Do I need to resize the image ?

Can anyone suggest a solution to either issue above? Is embedding the image more cost effective in terms of size of report

Thanks in advance
Roy

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,065 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 41,496 Reputation points
    2020-09-23T02:15:26.333+00:00

    Hi @RoyB09

    I also tried to set the image as the background of the rectangle and set the property to "clip".

    After that, I manually adjusted the rectangle size as shown below.

    If the rectangle’s size is smaller than the image’s size, then just part of the image will be displayed in the rectangle. If you want to display the whole image in the rectangle, then you need to adjust the size of the rectangle.

    If the size of the rectangle can't be change, I think you may need to resize the image to fit the rectangle.

    26605-screenshot-2020-09-23-095450.jpg
    26655-screenshot-2020-09-23-095318.jpg
    26693-screenshot-2020-09-23-095122.jpg

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. RoyB09 306 Reputation points
    2020-09-23T13:25:23.49+00:00

    Thank you for getting back to me.

    I've had the image resized to the same size as my rectangle i.e 33.86582cm X 19.05cm. The image looks almost okay in SSRS preview, except the logo is a little off center. but when I export the report to PowerPoint, the image repeats repeats on the slide.

    I tried all options to try and fix it, but can't seem to manage it?

    Regards
    Roy


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.