I. Overview
1. Application scenarios
Users want to export the results directly without previewing the report. For example, click a label or a button in the system to export the report.
2. Function description
Add &format = export format directly after the URL of the preview report. By assigning an export format to the format parameter, the URL can be exported directly.
The file name of URL direct export is the report name by default. If you need to rename, please refer to: export rename.
II. Parameter value of the export format
The parameter values corresponding to various export formats are shown in the following table:
| export formatt | type | parameter value |
|---|---|---|
| &format=pdf | ||
| Excel | Full Page xlsx | &format=excel |
| Unaltered xlsx | &format=excel&extype=simple | |
| Page to sheet xlsx | &format=excel&extype=sheet | |
| Full Page xls | &format=excel&extype=page&isExcel2003=true | |
| Unaltered xls | &format=excel&extype=simple&isExcel2003=true | |
| Page to sheet xls | &format=excel&extype=sheet&isExcel2003=true | |
| Word | &format=word | |
| Image | JPG | &format=image&extype=JPG |
| PNG | &format=image&extype=PNG | |
| GIF | &format=image&extype=GIF | |
| BMP | &format=image&extype=BMP | |
| text | &format=text Note: Pictures，oblique lines cannot be exported | |
| SVG | &format=svg | |
| CSV | &format=csv | |
Precaution:
1) Jar package before October 10, 2016, the exported excel format is XLS by default.
2) When exporting a specified sheet to a multiple sheet report, the parameter value is: &sheets = [sheet serial number], and the sheet serial number starts from 0. When exporting multiple sheets, the serial numbers are separated by commas. For example, export sheet 1: &format = excel & sheets = [0], export sheet 1 and sheet 2: &format = excel&sheets = [0,1].
3) Add JS to the button of the parameter pane to get the value of the current report sessionid, and splice the URL. When exporting excel, if you want to export the control value modified on the page and the value transferred to the cell by the control in the parameter panel, you need to export the parameter with OP=export&format=excel instead of &format = excel.
III. Example
This paper is based on GettingStartedEN.cpt export to PDF style, for example, to see how to export URL directly.
1. Open template
Open template %FR_HOME%\webapps\webroot\WEB-INF\reportlets\GettingStartedEN.cpt
2. Browser side export
Click pagination preview, add Parameter &format = PDF after URL, and click enter to export PDF file, as shown in the figure below:
Note: if there are parameters in the template, other parameters can be added to the URL. This example exports the results according to the default values of the parameters.
