Page Report Tab Properties

• <Server Setting> - Select to adopt the format setting on Server.
• Page Report - Select to view the report tab in Page Report Studio. Select the ellipsis in the value cell to configure the format options in the Page Report Option dialog box.
• HTML - Select to view the report tab in HTML. Select the ellipsis in the value cell to configure the format options in the HTML Option dialog box.
• PDF - Select to view the report tab in PDF. Select the ellipsis in the value cell to configure the format options in the PDF Option dialog box.
• Excel - Select to view the report tab in Excel. Select the ellipsis in the value cell to configure the format options in the Excel Option dialog box.
• Text - Select to view the report tab in Text. Select the ellipsis in the value cell to configure the format options in the Text Option dialog box.
• RTF - Select to view the report tab in RTF. Select the ellipsis in the value cell to configure the format options in the RTF Option dialog box.
• XML - Select to view the report tab in XML. Select the ellipsis in the value cell to configure the format options in the XML Option dialog box.
• PostScript - Displays the report tab in PostScript. Select the ellipsis in the value cell to configure the format options in the PostScript Option dialog box.

This property only controls the results of reports you run from the interface directly, but has no effect on the results of advanced reports or scheduled reports.

Data type: Enumeration

• Flow Report - A regular flow layout report.
• Banded Report - A restricted flow layout report, which is a layout intended for Logi Report Version 7 compatibility only.

Data type: Integer

• true - If you set the property to "true", when users opening the report tab in Page Report Studio, Logi Report Engine converts all the queries the data components in the report tab use to appropriate business views automatically for analytic reporting purpose. If the conversion fails due to error or incomplete conditions, Logi Report Engine displays no warning message on UI but records the information into the log file.
• false - If you set the property to "false", Logi Report Engine does not perform the conversion of queries to business views automatically when users open the report tab in Page Report Studio; instead, it converts the query a data component uses to a business view respectively when users perform an analytic reporting action on each data component, such as adding a field into the data component.

Data type: Boolean

Data type: String

Data type: String

Data type: String

Data type: String

Data type: String

For example, you can create a JavaScript file that contains the following function:

function promptMessage(message)
    {
    alert(message);
    }
window.promptMessage("test")

Data type: String

Data type: Boolean

For example, for a String type parameter which requires a value that is of 4-7 characters, you can define a formula like this:

if(length(@P_String) > 8 ) "The value is too long."
else if (length(@P_String) < 3 ) "The value is too short."
else ""

Then, when users specify a string value of 9 characters to the parameter, Logi Report Engine displays the message "The value is too long.".

When you define the formula, you need to make it return a blank string for valid parameter values.

Data type: Object Array

Data type: String

Data type: Boolean

Data type: Boolean

Data type: Boolean

When you use the report tab as a subreport, choosing any style group from the drop-down list turns on the Style Group feature for the report tab, meaning, it inherits the style group from the primary report; choosing "none" or leaving this property blank turns off the Style Group feature for the report tab, meaning, it does not inherit style group from the primary report.

When you use the report tab as a linked report, if you select "Pass style group information down to linked report" while defining the link condition, the report tab inherits the style group from the primary report; if you do not select that option, it applies the style group that you specify for the property.

Data type: String

Data type: Boolean

For example, you can specify the column width like this:

12;8;15;10;9

The example specifies the width of the first 5 columns. For the other columns, they take the default width of Microsoft Excel sheet. 8 is the default column width in a Microsoft Excel sheet, and you can omit it, so you can also set the above example as:

12;;15;10;9

Data type: String

If the report tab contains a subreport, Logi Report Engine disables the Column Width List property of the subreport when generating the Excel output for the report tab.

Data type: Boolean

Data type: Integer

This property does not take effect if you export the report to Excel using Data Format.

Data type: Boolean

Data type: Boolean

Data type: Boolean

Exporting a report tab to an Excel file without page breaks means the split pages are technically merged within the Excel sheet, which could bring the following results and limitations:

• In the Excel output, only one page header panel and one page footer panel in a banded object can display in each sheet. Only the first banded page header and the last banded page footer display in the output. As for tables, Logi Report Engine only exports the first table header and the last table footer.
• You cannot get a continuous table or banded object if the report tab contains other objects in horizontal locations. Logi Report Engine exports all split parts of a horizontal table vertically.
• Merging tables or crosstabs together extends the Excel sheet, which may cover other objects if they happen to be in the extended direction. Merging crosstabs together might extend the column/row index over the Excel sheet range, so you may lose the report part which is out of this range in the output.
• If a whole merged crosstab gets quite large, it might cause an out of memory error during the export process.

For the Excel version of Excel 97-2003 Workbook (*.xls), the value ranges from 0 to 65000, and any value out of the range is considered as 65000; for the Excel version of Excel Workbook (*.xlsx), the value ranges from 0 to 1048000, and any value out of the range is considered as 1048000.

When you export a report to Excel, Logi Report Engine does not separate the rows in the same page and exports them to different worksheets, thus the number of rows it exports to a worksheet may be greater than the maximum number of rows that you set for the property. For example, if you set the value of Rows per Sheet to 100, Logi Report Engine exports all the contents of the first page to the first worksheet, then it tests the rows of the first worksheet automatically: if the number of rows is less than 100, it still exports the Next Topic to the first worksheet even when the number of rows in the first page and the Next Topic is greater than 100; if the number of rows in the first page is equal to or more than 100, it generates a new worksheet and exports the second page to the new worksheet.

Data type: Integer

For a query-based report tab, if Logi Report Engine splits it into several sheets in the Excel output because of limited rows per sheet, it adds a postfix number to the sheets starting from the second one (SheetName, SheetName1, SheetName2, SheetName3...).

Data type: String

Excel does not support using the following characters in the sheet name: "|", ":", "/", "?", "\", "*", "]", "[", and the single quotation mark (') as the last character either. If you use any one of them in the value of the property, Excel replaces it with "_".

Data type: String

Data type: String

Data type: String

Data type: String

Data type: String

Data type: String

Data type: String

Data type: String

Data type: String