Format tab

This tab allows you to specify the format in which you would like to generate the report and set its corresponding settings. See the tab.

Select Format section

Specifies the format of the report result.

Select Format

Specifies the format in which the report result will be. It can be one of the following:

Web Report
Page Report
HTML
PDF
Excel
Text
RTF
XML
PostScript
Applet

Advanced section

Specifies some advanced format settings.

Enable Style Group

When this option is disabled as default, use the style group property of the page report tab or web report for this format that is predefined in JReport Designer to run the page report tab or web report.

When this option is enabled, you are allowed to select a style group from the Style Group drop-down list to run the page report tab or web report in the format.

Enable Converting Encoding

Specifies whether to enable the conversion of encoding. If checked, the Before Converting and After Converting options will be activated. Select the encoding from the drop-down lists as required.

Enable NLS

Specifies whether to enable NLS for the report. If checked, the Using Language drop-down list will be displayed for you to choose a language.

Notes:

The Enable NLS option is available only when the National Language Support option is checked in the Properties dialog of the report on the JReport Administration page.
If there is no NLS resource defined for the report, you can only run the report using the default language.

Encoding

Specifies the encoding for the report.

Connect to [Data Source Name] [Connection Name]

Specifies the DB user and password with which you want to connect to the data source the report uses. For the default connection, [Connection Name] will not be shown or recorded.

Use the DB user and password defined in catalog
If checked, the DB user and password defined in the catalog will be used.
Use the DB User
If checked, specify another DB user and password instead of the one defined in the catalog.

Add TaskListener to be Invoked

Specifies whether to enable the user to call the Java application before/after viewing. Enabled only when the format is not specified to Page Report Studio.

Web Report

Runs a web report in Web Report Studio.

Resolution

Specifies the resolution of the result to zoom in/out, in DPI. The default value is obtained from the operation system, which is the resolution of your monitor, for example, 72 DPI on Unix or 96 on Windows. You can set higher/lower value to zoom in/out.

Page Report

Runs a page report in Page Report Studio.

Resolution

Profile

Specifies the Page Report Studio profile to be applied to run the report, which contains a set of Page Report Studio settings.

Background Mode Timeout

Specifies the time after which the report will continue to run in background mode. When a page report runs and the results have not yet been generated after the specified time, it will automatically be switched to run in background mode. Once the report is complete you can find the results in the My Tasks > Background Tasks tab.

HTML

No Margin

Removes the margins you originally set while designing the report.

Multiple Files

Generates the report result to multiple HTML files. JReport designates a serial number for each HTML page. For example, if you named a 3-page report as "sales", JReport will create three files called sales_1.html, sales_2.html, and sales_3.html.

Embedded CSS
Specifies to embed the cascading style sheet (CSS) in the HTML files; otherwise, the .css file will be generated individually.

Single File

Generates the report result to a single HTML file.

No Hyperlink
If checked, there will be no hyperlinks for navigating previous and next pages on the navigation bar of the generated HTML file.
No Page Number
If checked, there will be no page number information showing the current page number and total page number on the navigation bar of the generated HTML file.

Drilldown

Generates the report result into an HTML file with the Drilldown feature enabled. The Drilldown feature enables you to inspect certain items for further detailed data.

Section 508 Compliant Output

If checked, the accessibility attributes defined for the report elements via the Report Inspector will be generated to the HTML result which is Section 508 compliant. See Accessibility for more information.

When Section 508 Compliant Output is checked, the Use HTML Data Table and Relative Font Size options will be checked and disabled. The output will be Section 508 compliant including HTML data table, accessible attributes, and relative font feature.

Use HTML Data Table

Specifies whether the table and crosstab components will be output as table objects in the HTML result.

Absolute Font Size

Generates the report result using an absolute font size, which means that the font size is fixed, and cannot be adjusted according to the font size settings in the web browser.

Relative Font Size

Generates the report result using a relative font size. The font size can be adjusted according to the font size settings in the web browser.

Use Chart

When publishing to e-mail or to FTP, only "Image Chart" is available for customization and "Use Chart" and "Applet Chart" is not needed.

Applet Chart
Uses a Java applet to display the charts in an HTML result file.
Image Chart
If selected, charts will be displayed as images. You can specify the image type from the drop-down list. The options are:
- Auto-select
  If selected, the image format will be detected to JPG or GIF by the JReport system automatically. If the image colors are less than 256 colors, GIF will be applied; otherwise, it is JPG.
- GIF
  If selected, the GIF format will be applied, which is a lossless compression technique and supports only 256 colors. GIF is better than JPG for images with only a few distinct colors, such as line drawings, black and white images and small text that is only a few pixels high.
- JPG (JPEG)
  If selected, the JPG (JPEG) format will be applied, which is supported on the Web. JPG is a lossy compression technique that is designed to compress color and grayscale continuous-tone images. JPG images support 16 million colors and are best suited for photographs and complex graphics.
- PNG
  If selected, the PNG format will be applied, which provides a portable, legally unencumbered, well-compressed (effectively 100 percent lossless compression), well-specified standard for lossless bitmapped image file. PNG supports indexed-color images of up to 256 colors and shows a more interchangeable, flexible and robust function than GIF.

Resolution

Specifies the resolution of the HTML result to zoom in/out, in DPI. The default value is obtained from the operation system, which is the resolution of your monitor, for example, 72 DPI on Unix or 96 on Windows. You can set higher/lower value to zoom in/out.

Web Browser

Specifies the web browser for which the HTML result adapts.

Text Overflow

Specifies whether the text overflow is visible or hidden.

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the HTML result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

PDF

No Margin

Removes the margins you originally set while designing the report.

Compress Image

Compresses the images in the report by the percentage you specify in the box.

Generate charts and barcodes using images (recommended)

When you run a report in PDF format, JReport will take the result of the whole report as a graphic to transform the report by the method of simulated printer and generate the report result in PDF format.

Generate charts and barcodes using vector graphics

The result of using Generate charts and barcodes using vector graphics is the same as with using Generate charts and barcodes using images (recommended). However, when you run a report in PDF format using Generate charts and barcodes using vector graphics, JReport will take the result of the whole report as a dataset to transform the report by sequence and to generate the report result in PDF format.

TOC

Generates the report result to PDF format with a Table of Contents. Not supported for web report.

Drilldown

Generates the report result to a PDF file with the Drilldown feature enabled. The Drilldown feature enables you to inspect certain items for further detailed data.

Encrypt

Specifies whether to encrypt the PDF file. If checked, click the Settings button to configure the encrypt settings in the Encrypt dialog.

Sign

Specifies whether to add the digital sign to the PDF file. If checked, click the Settings button to configure the sign settings in the Sign dialog.

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the PDF result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

Excel

Excel Version

Specifies the Excel version to be used.

Excel 97-2003 Workbook (*.xls)
Runs the file as .xls format.
Excel Workbook (*.xlsx)
Runs the file as .xlsx format.

Format

Specifies the format of the Excel result.

Report Format
If checked, JReport will attempt to make the formatting of the report in Excel match the format as designed in the template. Usually this format is recommended if you just want to view the report in Excel.
Column Format
If checked, the calculation method used for all components' row/column values in the report will be decided by the Columned property value of the report specified at report design time when exporting. This method is recommended when you want to actively use the result in Excel such as filtering and sorting.
Data Format
If checked, only the report data will be generated without format. This option is only available for the Excel version Excel 97-2003 Workbook (*.xls).

More/Less Options

Click to show/hide the additional settings for running the report to Excel. When Data Format is selected, only Word Wrap is available here.

Include Shapes in Export
Specifies whether to include the drawing objects in the Excel result, such as line, oval, and box.
Print Page Header
Specifies the page header text for the printed file.
Print Page Footer
Specifies the page footer text for the printed file.
Word Wrap
Specifies the word-wrap settings.
- All Keep Existing
  Keeps all the settings of each object's Word Wrap property originally specified in the report.
- All Disabled
  Disables the Word Wrap property for all objects. That is, the Word Wrap property is made false for all objects.
- All Enabled
  Enables the Word Wrap property for all objects. That is, the Word Wrap property is made true for all objects.
Print Gridlines
Specifies whether to include gridlines when printing the Excel result.
Run Linked Report
If the report is linked with other reports, you can check whether or not to generate the linked reports in the Excel result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

Text

Delimited Format

Generates the report result to a standard Text file, using a delimiter you specify to separate the fields.

Use Quote Mark
Specifies to use quote marks in the Text file.
Repeat Last Column Value If Null
If checked, when a cell in the generated CSV Text file has no value, value of the previous cell in the same column will be used.
Customize Delimited
Fields in the generated Text file will be separated by a user defined delimiter. You can type your own delimiter in the Delimiter box.
Tab Delimited
Specifies to use a Tab delimiter to separate the fields.
CSV Format
Exports to CSV format Text file.

Horizontal Density

Specifies the value for each unit of the horizontal density between columns. The resulting density is a direct ratio of the value you specify. That is, the greater the value, the smaller the width between columns. By default the density will be specified by JReport.

Vertical Density

Specifies the value for each unit of the vertical density between columns. The resulting density is a direct ratio of the value you specify. That is, the greater the value, the smaller the height between columns. By default the density will be specified by JReport.

Notes:

When using user defined densities, if the densities are not set appropriately, the fields in the report may overlap each other, so you are not recommended to use this way to run the report result to Text.
When setting the value of Horizontal/Vertical Density, you need to pay attention to the following:
- The value of Horizontal/Vertical Density must be greater than the character's width/height of the smallest field in the report (smallest field is the field with the smallest font size), otherwise, the value you set will not be applied.
- If the value of Vertical Density is greater than 0 and the value of Horizontal Density is less than 0, the value that you specify for the Vertical Density will be applied and the value of Horizontal Density will be specified by JReport.
- If the value of Vertical Density is less than 0 and the value of Horizontal Density is greater than 0, the value that you specify for the Horizontal Density will be applied and the value of Vertical Density will be specified by JReport.
- If the values of Vertical Density and Horizontal Density are both greater than 0 and the value of Horizontal Density is less than 11, the specified value of the two densities will be applied. Otherwise, they will be specified by JReport.
- If the values of Vertical Density and Horizontal Density are both less than 1, these densities will be specified by JReport.

Compress

Specifies whether to generate the report result to Text format in a compressed size, that is to say, there will be no clearance between the columns.

Header and Footer

If checked, the Text file will contain all headers and footers in the report, including Report Header/Footer, Page Header/Footer and Group Header/Footer. Otherwise, the Text file will only contain data in Detail panel.

Windows End-of-line (CR-LF)

Specifies to use Windows end-of-line characters to indicate the start of a new line. If checked, two characters <cr> and <lf> will be used at the end of the line.

Unix End-of-line (LF)

Specifies to use Unix End-of-line characters to indicate the start of a new line. If checked, only the Unix End-of-line character <lf> will be used.

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the Text result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

RTF

Best Editing

Specifies whether to apply flow layout for the RTF result.

No Margin

Removes the margins you originally set while designing the report.

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the RTF result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

XML

Only Data

If checked, the generated XML file will only contain the database column information. The generated XML schema file will only contain the structure information of the report.
If unchecked, the generated XML file will also contain elements controlled by formulas, and the generated XML schema file will contain all the detailed information from the report, including all the property values of each report object.

Schema File Name

Specifies the directory and the name of an existing XML schema (.xsd) file. If you specify an existing XML schema file, the generated XML file will be based on it. Otherwise, a new XML schema file will be generated to the directory where the XML file is generated. The new XML schema file and the XML file will have the same name but with different extensions.

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the XML result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

PostScript

No Margin

Removes the margins you originally set while designing the report.

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the PostScript result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

Applet

Pop-up Window

Specifies to show an Applet window when viewing a report.

Zip Result

Specifies to compress the result and its size would be smaller.

Java Plug-In 1.2 for Windows

Directs applets to run using Sun's Java Runtime Environment (JRE).

Java Plug-In 1.3 for Windows

Directs applets to run using Sun's Java Runtime Environment (JRE).

Run Linked Report

If the report is linked with other reports, you can check whether or not to generate the linked reports in the Applet result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

Notes:

You'd better specify a file destination when running a report via Applet, such as D:\folder\filename.pdf in case you may not find the result. By default when running a report via Applet on Internet Explorer, the generated result will be located on the Desktop, and when on Firefox, it will be in its installation root.

If you do not have read or write permission to the default location or the location you specified, you will get an access denied error. To handle this, add the required permission in jdk\jre\lib\security\java.policy that the applet uses:

For the default location "Desktop":

permission java.util.PropertyPermission "user.dir", "read"; permission java.io.FilePermission "${user.home}${/}Desktop${/}*", "read,write";

For user defined location:

permission java.io.FilePermission "D:${/}temp${/}*", "read,write";
When advanced running a report to Applet on Firefox, after you select File > Open Result File on the Report Viewer, you may get the access to the Open dialog denied error as follows:
java.security.AccessControlException: access denied (java.io.FilePermission Open read)

To resolve this, add the required permission in java.policy that the applet uses:
permission java.io.FilePermission "Open", "read,write";