Previous Topic
Page Report Tab Properties
This topic describes the properties of a Page Report Tab object.
| Property Name | Description |
|---|---|
| General | |
| Default Format for Viewing Report | Specifies the default format to view the report tab on Server. Default is to adopt the format setting on Server. If you select a specific format, you can further configure the format options.
Choose an option from the drop-down list.
Data type: Enumeration |
| Instance Name | Designer displays this property when the page report tab uses query resources. It shows the instance name of the report tab and is read only. |
| Report Layout Type | Designer displays this property when the page report tab uses query resources. It shows the layout type of the report tab and is read only.
|
| Result Buffer | |
| Result Buffer Size | Specifies the number of the report pages to store in the buffer.
The default size 4 indicates Logi Report Engine allocates four pages of the report to the result buffer, and stores the other pages on disk. If you have enough memory, you can increase the result buffer size to store more pages of the report, so that you can get better performance.
Data type: Integer |
| Data (available to query-based page report tab) | |
| Automatic Cube Initialization | Specifies whether to enable automatic conversion of queries into business views at runtime for the report tab.
Data type: Boolean |
| Others | |
| After Init Parameter | Designer displays this property when the page report tab uses query resources. You can use it to implement the Exit functions. Specify an external application file (Java class file) which develops an action, Logi Report Engine then calls the action after you specify parameters when running the report tab. Data type: String |
| After Run | Designer displays this property when the page report tab uses query resources. You can use it to implement the Exit functions. Specify an external application file (Java class file) which develops an action, Logi Report Engine then calls the action immediately after it finishes running the report.
Data type: String |
| Before Run | Designer displays this property when the page report tab uses query resources. You can use it to implement the Exit functions. Specify an external application file (Java class file) which develops an action, Logi Report Engine then calls the action at the point it is about to run the report tab.
Data type: String |
| Click Priority | Specifies the priority of the actions to be triggered at runtime when users select certain objects which are bound with some actions in the report tab. Select the ellipsis  in the value cell to set the priority in the Click Priority dialog box.
Data type: String |
| Embedded Fonts | Specifies the True Type Fonts that you want to embed in the PDF output of the report tab, if you have used TTF in the report tab. You can select multiple fonts from the value drop-down list by pressing the Ctrl or Shift key. For more information, see Delivering TTF in PDF. Data type: String |
| Import JavaScript | Designer displays this property when the page report tab uses query resources. You can use it to specify the name of a JavaScript file you develop to apply customized functions to the report tab in Page Report Studio, for example, test.js. You should save the JavaScript file in <server_install_root>\public_html\javascript\dhtml, and it will work together with API.js in the same folder, but with a higher priority if both of them contain the same functions.For example, you can create a JavaScript file that contains the following function:
Data type: String |
| No Temp File | Specifies whether to create temporary files for the report tab. You gain faster performance if you do not create the temporary files (true), while have better accuracy in data calculation with the temporary files (false). Data type: Boolean |
| On Parameter Value Change | Specifies the formulas for validating the parameter values in the report tab. After you specify the formulas, when users change the parameter values at runtime, Logi Report Engine passes the values to the formulas first for validation: if the values are valid, Logi Report Engine applies them to the parameters; otherwise, it displays the messages you define in the formulas. Choose the formulas from the drop-down list (to select multiple formulas, use the Ctrl or Shift key on the keyboard, then select outside of the value cell to confirm).
For example, for a String type parameter which requires a value that is of 4-7 characters, you can define a formula like this:
Then, when users specify a string value of 9 characters to the parameter, Logi Report Engine displays the message "The value is too long.".
Data type: Object Array |
| Page Background | Specifies the background color of the report page. Choose a color from the drop-down list or select Custom to customize a color in the Pick a Color dialog box. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
| Precision Sensitive | Designer displays this property when the page report tab uses query resources. You can use it to specify whether to enable customized precision settings for the output of the report tab. If you do not care the report visual effect, leave the value of the property to "false" (the default behavior) to let Logi Report Engine deal with the precision. Logi Report Engine has better performance when precision insensitive than when sensitive. When you set this property to "true", Logi Report Engine applies the precision level you specify for each export format in the output. Data type: Boolean |
| Remove Extra Characters from First Line | Specifies whether to remove the quotation marks and commas from the first line of the report tab's Text and CSV outputs.
Data type: Boolean |
| Show Subreport Header Footer | Specifies whether to show the page header and footer panels of the subreports in the report tab when the panels are visible in the subreports. Data type: Boolean |
| Style Group | Specifies the style group for the report tab.
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 |
| Suppress Object Space If Not Exported | Specifies whether to suppress the space for holding the objects in the output of the report tab, if you have specified to exclude them from exporting.
Data type: Boolean |
| Work as Subreport | Specifies whether to use the report tab as a subreport only. If you set this property to "true", when users run the corresponding page report in Page Report Studio, they are not able to open the report tab from the Go To drop-down list or by switching tabs. |
| Excel | |
| Column Width List | Designer displays this property when the page report tab uses query resources. You can use it to specify the width of the columns beginning from the first column for the Excel output of the report tab. Use semicolon (;) to separate each width. If you do not want to specify the width for a certain column, omit the value, Logi Report Engine then applies the default value 8 for the column. This property takes effect when you export the report to Excel using Column Format and set Columned of the report tab to "true". 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 preceding example as: 12;;15;10;9 Data type: String
|
| Columned | Specifies whether to turn on the properties related with exporting the report tab to a columned file, such as Excel and CSV. Data type: Boolean |
| Excel Buffer Size | Designer displays this property when the page report tab uses query resources. You can use it to specify the number of the report sheets to store in the buffer when exporting the report tab to Excel. The default size 1 indicates that Logi Report Engine allocates one sheet of the report to the result buffer, and stores the other sheets on disk. If you have enough memory, you can increase the Excel buffer size to store more sheets of the Excel output, so that you can get better performance.
Data type: Integer
|
| Fast Pass | Designer displays this property when the page report tab uses query resources. If you set it to "true", users can get better performance when running the report tab to CSV in multiple threads on Server. This property takes effect when you set Columned of the report tab to "true". Data type: Boolean |
| Full Fill and Border | Specifies whether to apply background color and display border for empty cells in the Excel output of the report tab, using the format you have specified in the report template. This property takes effect when you export the report tab to Excel using Report Format or Column Format; and if you use Column Format, you should set the report tab's Columned property to "false".
Data type: Boolean |
| No Page Break for Column Format | Specifies whether to remove the page breaks on each individual sheet when you export the report tab to Excel using Column Format. Data type: Boolean |
| No Page Break for Data Format | Specifies whether to remove the page breaks on each individual sheet when you export the report tab to Excel using Data Format. Data type: Boolean |
| No Page Break for Report Format | Specifies whether to remove the page breaks on each individual sheet when you export the report tab to Excel using Report Format. Data type: Boolean |
| Rows per Sheet | Designer displays this property when the page report tab uses query resources. You can use it to specify the maximum number of rows in every worksheet for the Excel output of the report tab. 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 |
| Sheet Name | Specifies the sheet name for the report tab in the Excel output. 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
|
| Style Group for Export (available to query-based page report tab) | |
| Excel Style Group | Specifies the style group for the Excel output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output. Data type: String |
| Fax Style Group | Specifies the style group for the fax output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output. Data type: String |
| HTML Style Group | Specifies the style group for the HTML output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output. Data type: String |
| Page Report Style Group | Specifies the style group for running the report tab in Page Report Studio. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group to run the report tab. Data type: String |
| PDF Style Group | Specifies the style group for the PDF output of the report tab. If you do not specify a value here, Logi Report Engine applies the value of Style Group in the output.
Data type: String |
| PS Style Group | Specifies the style group for the PostScript output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output.
Data type: String |
| RST Style Group | Specifies the style group for the RST output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output.
Data type: String |
| RTF Style Group | Specifies the style group for the RTF output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output.
Data type: String |
| Text Style Group | Specifies the style group for the Text output of the report tab. If you do not specify a value here, Logi Report Engine applies the value of Style Group for the output.
Data type: String |
| XML Style Group | Specifies the style group for the XML output of the report tab. If you do not specify a value for this property, Logi Report Engine applies the value of Style Group in the output.
Data type: String |
Automatic Cube Initialization
In order for users to perform analytic reporting actions on a query-based report component developed in Designer in Page Report Studio, Logi Report Engine needs to convert the component from query based to business view based.
When the conversion is required
The conversion is required when a user is trying to perform an analytic reporting action such as drilling through data on a crosstab that uses a query resource in Page Report Studio.
If the Automatic Cube Initialization property of a report tab is "true", Logi Report Engine automatically converts the queries the report tab uses to business views when a user opens the report tab in Page Report Studio.
What makes the conversion successful
The success of the conversion lies in the following aspects:
- There should be a business view using only the query that a data component applies as the data resource.
- All the fields in the data component have corresponding elements in the business view. For the mapping relationship, see How to convert.
- The cases described in What cannot be converted should be avoided.
The report designer can create a complete and full function business view for the required query. In this way, Logi Report Engine is able to convert all fields in the query because there are always corresponding view elements in the complete business view. To create such a complete business view, create a group and a detail element for each DBField and formula, and create an aggregation for each summary.
The following lists how Logi Report Engine converts each type of the fields in a query to the corresponding view element.
| If a query field is used as | Convert it to |
|---|---|
| Group-by field, crosstab column/row field, chart category/series field | Group object |
| Crosstab summaries | Aggregation object |
| Show Value in chart and is a summary | Aggregation object |
| Show Value in chart and is of Number type | Detail object |
| Static summary in the current or child group level, that is, the group-by field of the static summary is the same as the one used for the current group level or an ancestor group level | Aggregation object |
| Others and there is corresponding detail object in the business view | Detail object |
| Others and there isn't corresponding detail object in the business view | Group object |
The following shows the cases in a query-based data component that do not support conversion. The list supposes that all the involved query fields have their corresponding view elements in the business view based on the query:
- Static summary (except that used as Show Value of chart or in the current or child group level).
- Dynamic summary (except when the summary's group-by level is 0).
- Formula that references summaries.
- Page level formula.
- DBField or formula used as group-by field but the group has a special function.
- Parameter used as group-by field.
- Chart in a banded object that uses inherited dataset.
- Table, crosstab, or banded object which uses inherited dataset.
- Table, crosstab, chart, or banded object when one of its child components cannot be converted (the child components exclude blank components and those having already been converted).
Columned
After setting Columned to "true", you can predefine the coordinates for all objects in a report when exporting the report to a columned file such as Excel and CSV, which helps improve Logi Report Engine's performance by saving the extra position calculating time during the export process. You can specify values of the following properties for each object to position them as you want in the output.
- Column Index, Row Index
- Column Number, Row Number. You can set the two properties for charts, images, and UDOs.
- Top Attach Column, Top Attach Row, Bottom Attach Column, and Bottom Attach Row. You can set the four properties for drawing objects.
Designer calculates the default values of these properties based on the position of each object in the report. Each time after you set Columned to "true" from "false", Designer recalculates the property values for all objects in the report and resets the values to the defaults (there is an exception: if both the Export to Excel and Export to CSV properties of an object are "false", Designer does not recalculate the values and instead preserves them as before).
No Page Break
When you export a report to Excel without page breaks, the column headings appear just at the top of the Excel spreadsheet and are not repeated throughout the report (the split pages are technically merged within the Excel sheet); while, if the report breaks to a new sheet, the page header displays once again.
However, exporting a report to an Excel file without page breaks 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 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.
Style Group for Export
You can use the Style Group for Export properties to preset a style group to the report tab for each export format. The Style Group for Export properties have higher priority than the Style Group property; however, if you do not specify a style group for an export format, the report output of this format applies the value that you specify for the Style Group property by default.
The Style Group for Export properties take effect in the following cases:
- Export or preview the report in Designer.
- Export the report in Page Report Studio.
- Run and advanced run the report or schedule to publish it to version/disk/email/FTP on Server.
When you select the View tab to preview a report tab in Designer, Designer selects the value that you specify for the Style Group property by default in the Select Style Group dialog box, but you can select another style group to use. In the view mode, if you further preview the view result in different formats or export it to different formats, the preview/output applies the style group of the view result, instead of the Style Group for Export property values.