Rendering word reports using XML and XSL to generate Word XML

Rendering word reports using XML and XSL to generate Word XML

Post by U2FmYW » Thu, 13 May 2010 11:46:01



We have a requirement where-in we need to export an SSRS 2005 generated
report in word document.
Since this is not available out of the box the solution chosen was XSLT as
described in this document -
http://www.yqcomputer.com/ (Rendering word reports using XML and XSL )

With this approach there still are certain blocking issues like

1/ Display rich text - Suppose we have HTML tags in the text they are thrown
out on the word document as text instead of rich text

2/ Charts - Export a chart into the word file (bar graphs)

3/ Tables - Dynamic table generation based on the data & coloring of cells
based on conditions.

The redering of all this needs to be on a word document and not HTML. Any
advices please let me know.
 
 
 

Rendering word reports using XML and XSL to generate Word XML

Post by Yves Dhond » Thu, 13 May 2010 14:55:12

I would go with rendering HTML. HTML files can be opened by Word and stored
in any format you want so that shouldn't be an issue.

Choosing HTML as the output type would solve your first issue. I also
believe it would be easier to generate tables in HTML instead of WordML. One
thing to keep in mind is that you should define the table columns with fixed
widths. Word has its own layout engine and doesn't always play nice with
non-fixed widths.

Yves