If the Microsoft Windows Region and Language of the client computer is set to English (United States), then the numbers and dates are formatted in en-US locale in the Excel 2007 output file. The formatting is handled by Microsoft Excel. BI Publisher saves the formatting mask and the actual value (date or number) into the XLSX output file. Note: For this output format BI Publisher does not apply any formatting for number and date. If your report consumers have Excel 2007 or later installed, this option provides the best preservation of layout and formatting. It does not support embedded images or nested tables.Įnable this option to generate the report in Excel.xlsx (Excel XML format). This option generates HTML that can be opened in Excel. This option supports embedded images, such as charts and logos nested tables are not supported.Įnable this output type only when report consumers are running the earlier versions of Microsoft Excel 2000 or 2002. This option generates an MHTML format file that can be opened in Excel 2003 or later. This field is not updatable.Įnable this option to generate comma separated value output.Įnable this option to generate XML output.Įnable this output type to view the report in Excel when report consumers have Microsoft Excel 2003. If this layout is for scheduled reports only, clear this box.ĭisplays the locale selected when the layout was uploaded. When a layout is inactive it does not display in the report viewer or the scheduler.īy default, a layout is available for report consumers who open the report in the Report Viewer. Clear this box when you want to keep the layout as part of the report definition, but no longer make it available.
For more information, see Applying a Style Template to the Layout.īy default a layout is active. Note that a style template can only be applied to RTF template files. Select this box to apply the style template to this layout. Only one box in this column can be checked. Select the layout that this report uses by default when viewed online or scheduled. Select the default output format for this layout when viewed or scheduled. See Selecting Output Formats for the complete list. The layout type determines the output types available. By default, all valid output types for a layout are enabled. Select the output types to be enabled for this layout.
Click the template file name to download it. Place the cursor in the text box to enter a new name for the layout.ĭisplays the name of the file that was saved to the report definition.
0 kommentar(er)
