Exporting to Microsoft Word Report Builder and SSRS The Word rendering extension renders paginated reports to the Microsoft Word format.The format is Office Open XML.The content type of files generated by this renderer is applicationvnd.See Export Reports Report Builder and SSRS for details on how to export to Word.After you export the report to a Word document, you can change the contents of your report and design document style reports such as mailing labels, purchase orders, or form letters.OiEe.jpg' alt='Microsoft Word Header Footer Hidden' title='Microsoft Word Header Footer Hidden' />Note You can create and modify paginated report definition.Report Builder and in Report Designer in SQL Server Data Tools.Each authoring environment provides different ways to create, open, and save reports and related items.Report Items in Word Reports exported to Word appear as a nested table that represents the report body.A tablix data region is rendered as a nested table that reflects the structure of the data region in the report.Text boxes and rectangles are each rendered as a cell within the table.The text box value is displayed inside the cell.Images, charts, data bars, sparklines, maps, indicators, and gauges are each rendered as a static image within a table cell.Hyperlinks and drillthrough links on these report items are rendered.Maps and areas that can be clicked within a chart are not supported.Newsletter style column reports are not rendered in Word.Report body and page background images and colors are not rendered.After the report is opened in Word, Word repaginates the entire report again based on the page size.This article shows all keyboard shortcuts for Microsoft Word.The shortcuts in this article refer to the U.S. keyboard layout.Keys for other layouts might not.This guide examines the elements of a professional report and reviews the structuring, styling, and finalizing of your document in Microsoft Word.Repagination may cause page breaks to be inserted in locations where you did not intend to add them and, in some instances, may cause the exported report to have two successive page breaks in a row or add blank pages.You can try to change Words pagination by adjusting the page margins.This renderer supports only logical page breaks.Page Sizing When the report is rendered, the Word page height and width are set by the following RDL properties paper size height and width, left and right page margins, and the top and bottom page margins.Page Width Word supports page widths that are up to 2.If the report is wider than 2.Word will not display the report contents while in print layout view or reading layout view.To view the data, switch to normal view or Web layout view.In these views, Word reduces the amount of whitespace, thereby displaying more of your report contents.When rendered, the report grows as wide as required, up to 2.The minimum width of the report is based on the RDL Width property in the Properties pane.Document Properties The Word renderer writes the following metadata to the DOCX file.Report Element properties.Description. Report Title report titleTitle.Report. Author. Author.Report. Description.Comments Page headers and footers are rendered as header and footer regions in Word.If a report page number or an expression that indicates the total number of report pages appears in the page header or footer, they are translated to a Word field so that the accurate page number is displayed in the rendered report.If the header or footer height is set in the report, Word cannot support this setting.The Print. On. First.Page property can under some circumstances specify whether text in a page header page footer prints on the first page of a report. Cracked Manifold Honda Civic 2002 more. If the rendered report has multiple pages and each page contains only a single section, then you can set Print.On. First. Page to False and the text is suppressed on the first and page otherwise, the text prints regardless of the value of the Print.On. First. Page property.The Word renderer attempts to parse all expressions in page headers and footers when reports are exported to Word.Many forms of expressions parse successfully and the expected values appear in page footers and headers on all report pages.However, when a page footer or page header contains a complex expression that evaluates to different values on different pages of a report, the same value might display on all report pages.The page numbers in the following two expressions do not increment in the exported report.The page number translates to the same value on all report pages.Page Globals Page.Number. To. String of GlobalsTotal.Pages. To. StringAvgFields YTDPurchase.Value, Sales Page Number Globals Page.Number. This occurs because Word renderer parses the report for fields related to pagination such as Page.Number and Total.Pages and handles only simple reference, not calls to a function.In this case, the expression calls the To.String function. The following two expressions are equivalent and both render correctly when you preview the report in Report Builder or Report Designer or render the published report in a Reporting Services web portal or a Share.Point library. However, the Word renderer parses only the second expression successfully and renders the correct page numbers.Complex expression Expression is Average Sales AvgFieldsYTDPurchase.Value, Sales Page Number Globals Page.Number. Expression with Text Runs Text, Average Sales, and expression, AvgFields YTDPurchase.Value, Sales, and text, Page Number, and expression Globals Page.Number. To avoid this problem, use multiple text runs instead of one complex expression when you use expressions in footers and headers.The following two expressions are equivalent.The first one is a complex expression the second one uses text runs.The Word renderer parses only the second expression successfully.Interactivity Some interactive elements are supported in Word.The following is a description of specific behaviors.Show and Hide The Word renderer renders report items based on their state when rendered.If a report items state is hidden, the report item is not rendered in the Word document.If a report items state is shown, the report item is rendered in the Word document.Toggle functionality is not supported in Word.Document Map If any document map labels exist in the report, they are rendered as Word Table of Contents TOC labels on the respective report items and groups.The document map label is used as the label text for the TOC labels.The target link is positioned near the item on which the label is set.While a TOC is not created for you in the Word document, you can build your own TOC using the document map labels that are rendered in the report.Hyperlink and Drillthrough Links Hyperlinks and drillthrough links on text box and image report items are rendered as hyperlinks in the Word document.When you click the hyperlink, the default Web browser opens and navigates to the URL.When you click the drillthrough hyperlink, the originating report server is accessed.Interactive Sorting The report contents are rendered based on how they are currently sorted within the report data region.Word does not support interactive sorting.After the report is rendered, you can apply table sorting within Word.Bookmarks Bookmarks in the report are rendered as Word bookmarks.Bookmark links are rendered as hyperlinks that connect to the bookmark labels within the document.Bookmark labels must be less than 4.The only special character that can be used in a bookmark label is an underscore.Unsupported special characters are stripped from the bookmark label name and, if the name is longer than 4.If there are duplicate bookmark names in the report, the bookmarks are not rendered in Word.Word Style Rendering The following is a brief description of how styles are rendered in Word.Color Palette Colors rendered in the report are rendered in the Word document.Border Borders for report items, other than the page border, are rendered as Word table cell borders.Squiggly Lines in Exported Reports When exported and viewed in Word, report data or constants might be underlined by red or green squiggly lines.The red squiggly lines identify spelling errors.The green squiggly lines identify grammar errors.This occurs when the report includes words that do not comply with the proofing spelling and grammar of the editing language that is specified in Word.For example, English report column titles will likely be underlined by red squiggly lines when the report is rendered in a Spanish version of Word.Perceived spelling errors are more common in reports than perceived grammar errors because reports typically include only short text, not complete sentences or paragraphs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |