Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, August 5, 2014 9:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 9:26 AM
Points: 72, Visits: 286
Hello,

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?

Thanks
Post #1599822
Posted Tuesday, August 5, 2014 7:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:49 PM
Points: 171, Visits: 501
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