Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Exporting SSRS report to Word without nested Tablix objects Expand / Collapse
Posted Tuesday, August 5, 2014 9:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, February 18, 2016 3:23 PM
Points: 76, Visits: 307

Does anyone have suggestions regarding how to export a SSRS report to Microsoft Word, without the SSRS reports tablix object? The scope is as follows:

Client wants a SSRS report developed. They want to have the report exported to Word. They would like to be able to edit the report in word after it has been exported. This issue is, the word document contains the tablix objects from SSRS, ie: Tablix, textbox, etc. What ever object used in SSRS to format the report is exported to word.

Is there a solution for this or viable work around?

Post #1599822
Posted Tuesday, August 5, 2014 7:54 PM


Group: General Forum Members
Last Login: Tuesday, April 12, 2016 9:13 PM
Points: 176, Visits: 541
The only suggestion I can think of is to design your report inside of a single text box in a table of one cell high and one cell wide. Format everything as you would in Word using spaces, hard returns, and in-line placeholders like you would merge codes. Then, after exporting to Word, copy the entire contents of document onto the clipboard, delete the table, and paste using the text-only or rich text "special" paste options.
Post #1600009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse