#### 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:

- DHTML
- 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 report for this format that is predefined in JReport Designer to run the report.

When this option is enabled, you are allowed to select a style group from the Style Group drop-down list to run the report in the format. This setting will cancel the predefined style group property of the report for this format and replace it with the value specified here to run the report. When the None item in the Style Group drop-down list is selected, no style will be applied when running the 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.

Encoding

Specifies the encoding for the report.

Use the default DB user and password defined in catalog

If checked, the default DB user and password defined in the catalog will be used.

Use the DB User

If checked, specify another DB user and password in the catalog instead of the default one.

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 DHTML.

With Load Balancer, prefer a server to run the task

Specifies whether to enable the user to directly specify a server in a cluster to perform a scheduled task or an advanced-run task instead of using load balancing. This option is available only when there are more than one active clustered servers in a clustered environment and when the Identify Server Preference option is selected in the Profile > Customize Server Preferences > Advanced tab.

##### DHTML

This format allows you to export your report set to a DHTML result that can be viewed in a JReport DHTML window. Some reports cannot be published to version in a DHTML result format, such as self-contained (CLX) reports, multi-level nested master and subreports, reports containing data objects, and reports developed from a dynamic query or hierarchical data source (HDS).

Resolution

Specifies the resolution of the DHTML 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.

Profile

Specifies the DHTML profile to be applied to run the report set, which contains a set of JReport Web settings.

Background Mode Timeout

Specifies the time after when the report set will run in background mode. When a DHTML report set runs and the results have not yet been generated after the specified time, it will be automatically be switched to run in background mode.

##### 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 exported 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 exported 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 exported 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 exported to the HTML format report 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 format 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

- Applet Chart
  Uses a Java applet to display the charts in an HTML format 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.

##### 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.

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.

##### Excel

Word Wrap

- 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.

Preserve Report Formatting

Specifies to adopt the original layout of the report set when exporting.

Normal Formatting

If checked, and the Columned property of the report was set to true in JReport Designer, the exported Excel file will be in columned format.

Excel 2000

If checked, only the report data will be exported without format.

More/Less Options

Click to show/hide the additional settings for exporting the report to Excel. When Excel 2000 is selected, there will be no more options.

- Include Shapes in Export
  Specifies whether to include the drawing objects in the exported Excel file, 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.
- Print Gridlines
  Specifies whether to include gridlines when printing the exported Excel file.

##### 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 exported CSV text has no value, value of the previous cell in the same column will be used.
- Customize Delimited
  Fields in the exported 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:

- By exporting 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 export 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 set 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.

##### RTF

Best Editing

Specifies whether to apply flow layout when exporting the report to RTF.

No Margin

Removes the margins you originally set while designing the report.

##### XML

Only Data

- If checked, the exported XML file will only contain the database column information. The exported XML schema file will only contain the structure information of the report.
- If unchecked, the exported XML file will also contain elements controlled by formulas, and the exported 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 exported XML file, the generated XML file that is to be exported will be based on it. Otherwise, a new XML schema file will be generated to the directory where the exported XML file is to be exported. The new XML schema file and the exported XML file will have the same name but with different extensions.

##### PostScript

No Margin

Removes the margins you originally set while designing the report.

##### 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).

Notes:

- You'd better specify a file destination when exporting a report set via Applet, such as `D:\folder\filename.pdf` in case you may not find the result. By default when exporting a report set via Applet on Internet Explorer, the exported 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 set 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";`