|
|
|
|
|
- Overview
- Creating a Spreadsheet report
- Creating the report
- Characteristics of a Spreadsheet report and a Spreadsheet control
- Handling a Spreadsheet control in a report programmatically
The report editor allows you to create "Spreadsheet" reports. In this case, the report contains a Spreadsheet control only. Note: This type of control is created when a Spreadsheet report is created, and can also be created independently of this report.. Creating a Spreadsheet report Creating the report To create a "Spreadsheet" report: - Click
in the quick access buttons. - The window for creating a new element is displayed: click "Report" then "Report".
- The report creation wizard starts.
- Select a "Spreadsheet" report.
- In the rest of the wizard, specify:
- the data source of the Spreadsheet control created in the report. This source can be:
- a data file item,
- a Spreadsheet control in a window.
- none, if Spreadsheet control is assigned programmatically.
- scaling options for the Spreadsheet control in the report:
- No scaling: The spreadsheet sheet is printed at its own size.. The print can be performed on several pages in width and in height if necessary.
- Fit the spreadsheet to the field dimensions: The spreadsheet will be reduced to fit entirely within the Spreadsheet control area..
- Fit all columns to field width: Columns in the spreadsheet will be reduced or enlarged so that all columns in the spreadsheet are displayed within the width of the field..
- Adjust all rows to field height: Rows in the spreadsheet will be reduced or enlarged so that all rows in the spreadsheet are displayed at the height of the field..
- the template used if necessary.
Characteristics of a Spreadsheet report and a Spreadsheet control You can modify the following characteristics of a Spreadsheet report: - By default, the Spreadsheet report is not linked to a data source. The Spreadsheet report data source can be modified in the "Data" tab of the report description window ("Report description" in the report context menu).
- The "General" tab of the Spreadsheet control description window allows you to specify the scaling characteristics of the Spreadsheet control.
- The "Content" tab of the Spreadsheet control description window allows you to link the Spreadsheet control to a data source:
- Memo item of a data file or query, etc.
Spreadsheet control in a window. - xlsDocument variable.
- The "Style" tab of the Spreadsheet control description window allows you to specify the style of the grid and header text displayed in the Spreadsheet control.
Handling a Spreadsheet control in a report programmatically You can associate the Spreadsheet of a report with: - a variable of type xlsDocument. Simply use the code:
<Spreadsheet control> = <xlsDocument variable> - an xls/xlsx file. Simply use the code:
<Spreadsheet control> = <Path of xls/xlsx file>
Warning: Spreadsheet control functions cannot be used on the Spreadsheet control of a report..
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|