How to change the rendering of SSRS reports when imported to PowerPoint?

sravya shivapuram 211 Reputation points
2021-03-26T23:56:37.62+00:00

When an SSRS report is imported to PowerPoint, it splits 1 page report into 2 slides ( splits the last column into 2 slides)

Is there a way to change the rendering of SSRS report in PowerPoint manually?

I am new to SSRS. Any help is greatly appreciated. Thank you in advance.

Regards
SLS

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

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-03-29T02:55:32.013+00:00

    Hi @sravya shivapuram
    When you export the report to powerpoint format, the table in powerpoint is also presented in image format.
    Just like in most rendering extensions - like PDF for example - you have to pay attention to the size of your report body and its objects inside. If not, it's possible your report is spread out over multiple PowerPoint slides. It can even happen that the generated image of your chart or table is divided in multiple pieces.
    So if you don't want to divide the last column into two pages, you could try to adjust the body size and tablix size at the same time.
    Here is an example:

    • Before adjustment

    82188-01.jpg

    • After adjustment

    82086-02.jpg

    Hope this helps.
    Best 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.