Full Page image from SSRS to PPT

ron barlow 411 Reputation points
2020-09-28T14:13:57.737+00:00

Hello

For about a week I
we’ve been trying to add an image in an SSRS report , that also exports to full slide PPT. Image attached

To cover the entire PPT slide, I have a 33.86582cm, 19.05cm rectangle. I’ve tried embedding an image into the rectangle. The image size is 1920 x 1080 pixels. for a 16:9 PPT default layout. The problem is the image doesn’t fit the rectangle. If I try to increase the size of the image, it sort of looks okay in SSRS but doesn’t export correctly to PPT. I’ve tried Background repeat of Clip, Default etc, but nothing works

I also tried dragging the image onto the rectangle and resizing it. This looks okay in SSRS and exports to PPT, but the problem is that if I add any text boxes on top of the image they appear at the bottom of the SSRS report, but export in the correct positions to PPT. I’ve tried Sending the image to the back and the text boxes to the Front, but again nothing works. The other issue is that the file size balloons by putting the image on top of the rectangle.

I cannot change the RSreportserver.cofig file and I am not a graphics person, so I don’t know how the ratio of image to rectangle should work? This is really causing an issue and other team members have tried to do this but they are also not image experts

Can anyone suggest a way I can fix this easily or are the rendering settings between PPT and SSRS to different?

Thanks
Ron

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.
2,735 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points
    2020-09-29T02:18:57.293+00:00

    Hi @ron barlow ,
    The attached image is missing, could you post again?
    So far as I understand, there is no direct settings here in SSRS to fit your demand in PPTX.
    The only work around would be that, you could firstly in SSRS design page , drag and resize the image to fit the rectangle. Then you need to keep the size of the image ,that shows in property.
    28935-01.jpg
    Then, in the image source, change the source image size. Make the source image the exact size as the one that is needed in SSRS . Use pixel- inch calculator to measure the size. You could try this tool:DPI Calculator
    At last we could import the image as rectangle background image. So that the textbox could show on the image other than at bottom. This should be able to work.
    Regards,
    Joy


    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. ron barlow 411 Reputation points
    2020-09-29T12:09:54.767+00:00

    Thanks joy

    We've found a work around. i.e we're using 2 images controlled by an Expression. !t renders one in SRRS and one in PPT. it's not pretty but it seems to work

    Ron