question

sravyashivapuram-6930 avatar image
0 Votes"
sravyashivapuram-6930 asked Joyzhao-MSFT commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @sravyashivapuram-6930
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.



01.jpg (12.9 KiB)
02.jpg (10.6 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Joyzhao-MSFT

Thank you for your response. Yes, I am looking for the same exact thing but could you please let me know where and how can I change the body and tablix size ?

Appreciate all your time and help.

Regards
SLS

0 Votes 0 ·
Joyzhao-MSFT avatar image Joyzhao-MSFT sravyashivapuram-6930 ·

Hi @sravyashivapuram-6930 ,
In the property bar, select "Tablix" and "Body" in the drop-down arrow respectively, find the "Size" option in the property, and then change the value. For more information, see the figure below:
82218-03.jpg

82271-04.jpg
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 Votes 0 ·
03.jpg (40.9 KiB)
04.jpg (18.2 KiB)

Thank you @Joyzhao-MSFT.

I tried to open the properties for the corresponding .rdl file but it seems to be empty. I modified the page width from 11in to 13in in the .rdl file but it didn't make any difference.

82435-screenshot1.png



Please help.

Regards
SLS

0 Votes 0 ·
screenshot1.png (209.7 KiB)
Joyzhao-MSFT avatar image Joyzhao-MSFT sravyashivapuram-6930 ·

What does your report look like?

0 Votes 0 ·