How to export table from report builder into editable format?

SudhaB 21 Reputation points
2020-11-13T22:26:06.367+00:00

Hi,
I am using Report Builder to export PowerPoint slides. The report has few text boxes and a table. The text boxes were exported into editable format that I can update in pptx slide however the table is being exported as an image.

Is there a way to export table in editable format in PowerPoint? I checked the rendering extension types and noticed that for PowerPoint, report builder uses hard page-break extension type which is also the same one for tiff. Is that why table is being exported as an image? If so, is there a way to override default rendering extension type?

Appreciate any help on this. Thanks!

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

Accepted answer
  1. ZoeHui-MSFT 36,116 Reputation points
    2020-11-16T02:13:45.373+00:00

    Hi @SudhaB ,

    Report builder uses hard page-break extension type when exporting to Power Point which is different with word's Soft page-break.

    When exported to PowerPoint, the table has been converted to an image as well and not to a PowerPoint table.

    https://www.mssqltips.com/sqlservertip/4115/exporting-sql-server-reporting-services-reports-to-powerpoint/

    It is by design so that we couldn't override default rendering extension type.

    The easiest to setup is using the Word export.

    With this export you can easily copy/paste the Word version into a PowerPoint deck or even use the embedding of Word documents directly into PowerPoint.

    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.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. SudhaB 21 Reputation points
    2020-11-17T01:12:12.793+00:00

    Thank you @ZoeHui-MSFT !

    I went through the Report Builder documentation and saw the same hard page-break extension type for .pptx export. Wanted to check if I am missing anything as I am new to Report Builder!

    Thank you so much for the quick reply!

    0 comments No comments

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.