Previous Topic  Next Topic

Options Dialog

The Options dialog appears when you select File > Options, or select Options on the Catalog Manager toolbar. It helps you to configure Logi JReport to your preferences and requirements and is divided into the following categories:

• General
• Editor
• Panel
• Format
• Dataset
• Component
• Preview
• Catalog
• Export to
• Print
• Query Editor
• Security
• Cache

Restore Defaults

Restores values of all options to be the default ones.

OK

Applies the changes and closes the dialog.

Cancel

Does not retain the changes and closes the dialog.

Apply

Applies the changes and leaves the dialog open.

Help

Displays the help document about this feature.

General

The following are details about options of this category. See the dialog.

Show welcome page

Specifies whether or not to show the welcome page when you start Logi JReport Designer.

Show version warning message when opening reports

Specifies whether or not to show the version warning message when a report of an earlier version is opened using a higher version. The message warns you that you are about to open a report which belongs to an earlier version, and if you save the report using the current version, you may not be able to open it with the earlier version of Logi JReport Designer again.

Show prompt message dialog when creating a blank report

Specifies whether or not to show the prompt message when a blank report is created. The message prompts you to drag and drop data components from the Components panel and data fields from the Data panel onto the blank report.

Show hidden objects

Specifies whether or not to show objects that are hidden in your report.

Show real view of subreport

Specifies whether or not to show the detailed structure of a subreport in its primary report in design mode.

Set maximum number of open reports

Specifies whether or not to limit the number of the reports that can be opened in Logi JReport Designer. If check, you can set the the maximum number of the reports that can be opened in Logi JReport Designer.

Set recently used report names to display

Specifies whether or not to display names of the recently used reports in the welcome page. If checked, you can set the number of report names that are recently used to display.

Backup files automatically before saving modifications

Specifies whether or not to generate the backup files (.cat.bak and .cls.bak ) of the catalog and report when they are saved.

High Precision View

Specifies the default value for the High Precision View option on the View menu.

Show tips

Specifies whether or not to show the tooltip when you hover the mouse over a property in the Report Inspector or Catalog Manager, or some dialog option.

Show warning message when CSS properties are not supported by Logi JReport

Specifies whether or not to show the warning message when the applied CSS style contains properties that Logi JReport does not support.

Check the availability of dynamic chart for Excel

Specifies to check if a chart can be correctly mapped to a banded object/table when you save the report or export it to Excel.

Default Chinese Encoding

• Convert
  Enables the converting encoding function. This function is applied to data which is stored using the Unicode UTF8 in the database. When this function is enabled, the changes will only be apparent when you view the report or export it to certain formats.

User Name

Specifies the user name which will be applied in cases when a user name value is required, for example, when the special field User Name is referenced in a report.

Editor

The following are details about options of this category. See the dialog.

Show status bar

Specifies whether to show the status bar in Logi JReport Designer.

Show ruler

Specifies whether or not to show the horizontal and vertical rulers in the main window of Logi JReport Designer.

Show guidelines

Specifies whether or not to show the guidelines in the main window of the reports.

Show paragraph marks

Specifies whether or not to show the paragraph marks in the design mode of Designer.

Show margins

Specifies whether to show the margins in the design area.

• Margin Line Color
  Specifies the color of the margin line that is to be displayed in reports. Select a color from the drop-down list or select Custom from the list to customize a color in the Pick a Color dialog.

Grids

Specifies the grid properties.

• Show grids
  Specifies whether to show grids in reports.
• Snap to grids
  Specifies whether to snap and lock objects with the grids when moving and placing objects around.
• Size
  Specifies the size of the grids in the design area.
• Color
  Specifies the grid color.

Display Attributes

Specifies the display attributes, which can also be set in the Display Attributes dialog.

• Decimals
  Specifies the precision of the fractional data in reports. For instance, if you set Decimal to 3, then all the property values of the objects in the Report Inspector will be rounded to the thousandth.
• Units
  Specifies the unit of the measurement in reports. It can be either centimeter or inch.
• Resolution
  Specifies the resolution. By default, it will be the resolution of your monitor.

Panel

The following are details about options of this category. See the dialog.

Show Components

Specifies whether to show the Components panel in Designer.

Show Data

Specifies whether to show the Data panel in Designer.

Show Catalog Manager

Specifies whether to show the Catalog Manager in Designer.

Show Inspector

Specifies whether to show the Inspector panel in Designer.

Report Inspector

• Forbid changing Query Name property
  Specifies whether to allow the changing of the property Query Name or Data Name in the Report Inspector.
• Forbid changing column
  Specifies whether to allow the changing of the property Column Name in the Report Inspector.
• Forbid changing parameter
  Specifies whether to allow the changing of the property Parameter in the Report Inspector.

Format

The following are details about options of this category. The format properties set here will be applied to all columns in a catalog. See the dialog.

Data Type

Specifies the data type of the columns.

Format

Specifies the format of the columns.

Font

Specifies the font properties of the column contents.

• Font Face
  Specifies the font face of the column contents.
• Font Size
  Specifies the size of the font.
• Horizontal Alignment
  Specifies the horizontal alignment of the column contents.
• Vertical Alignment
  Specifies vertical alignment of the column contents.
• Foreground
  Specifies the color of the font foreground. Select a color from the drop-down list or select Custom from the list to customize a color in the Pick a Color dialog.
• Autofit
  Specifies whether to adjust the width according to the contents.
• Word wrap
  If checked, the contents will be wrapped.
• Italic
  If checked, italic fontface will be used.
• Underline
  If checked, the contents will be underlined.
• Strikethrough
  Specifies whether or not to draw a line through the column contents.
• Bold
  If checked, fold fontface will be used.

Border

Specifies properties of the column border.

• Border Width
  Specifies the width of the border. Can be from 1 to 3 points.
• Border Color
  Specifies the color of the border. This works only if you specify lines for the borders.
• Top Line
  Specifies the top border line style.
• Bottom Line
  Specifies the bottom border line style.
• Right Line
  Specifies the right border line style.
• Left Line
  Specifies the left border line style.
• Shadow
  Specifies to draw a shadow to the border.
  • Shadow Color
    Specifies the color for the shadow.

Background

Specifies the color for the background of the columns.

Null Display

If there is no value in a column, Logi JReport will display NULL as default. You can also set what will be displayed when there is no value in the column by inserting the mouse in the Report Inspector and inputting a value.

Pattern Style

Specifies the pattern for the columns.

Pattern Color

Specifies the color to draw the pattern.

Padding

Specifies the spaces between the contents of a column and its borders.

• Top Padding
  Specifies the space between the contents of a column and its top borders.
• Bottom Padding
  Specifies the space between the contents of a column and its bottom borders.
• Left Padding
  Specifies the space between the contents of a column and its left borders.
• Right Padding
  Specifies the space between the contents of a column and its right borders.

Dataset

The following are details about options of this category. See the dialog.

Use the current dataset when the requested data values are available in the current dataset

Specifies whether or not to use the current dataset when the requested data values are available in the current dataset.

Inherit dataset when component's dataset is the same as its parent's

Specifies whether or not to inherit dataset when component's dataset is the same as its parent's dataset.

Component

The following are details about options of this category. See the dialog.

Insert component with static/relative/absolute position in flow layout report

Specifies the default method with which to place components:

• static
  If selected, the component will be positioned at the top left of the location in which it is inserted. There are no X and Y coordinate property values.
• relative
  If selected, the component will be positioned at an offset to the position in which it is inserted. The offset is determined by the X and Y coordinate property values. Not all components support relative position.
• absolute
  If selected, the component will be located at the position specified by dragging and dropping or by setting its X and Y coordinate property values.

See the Position property for more information.

Insert field name label with field

Specifies whether or not the fields will be inserted into reports together with their default name labels.

Insert group name label with group

Specifies whether or not the groups will be inserted into reports together with their default name labels.

Customize group indent

Specifies whether to customize the indent of groups created via the report wizard. By default, the indent of the groups is 0 inch or centimeter. You can also input a value between 0 and 4 to customize the indent.

If this option is not checked, when you create groups in a report in the report wizard, the groups will be indented according to the width of the group by fields.

Qualify Group/Sort field by connection

By default, any field added to the catalog in Logi JReport can be used to group and sort. However, you can specify here whether or not a field can be used to group or sort. The qualification information will be stored in the database connection.

Horizontal Gap of Crosstab

Specifies the horizontal gap between two parts of a crosstab, which is split according to the page settings.

Vertical Gap of Crosstab

Specifies the vertical gap between two parts of a crosstab, which is split according to the page settings.

Display abbreviations for panel labels of banded object and table

Specifies whether to display abbreviations for the panel labels of banded object and table in the design area. By turning this off you can see the full name plus the group by field name.

Align summaries vertically

Specifies whether to align the summaries that are added to tables and banded objects via the report wizard vertically. For tables, this option takes effect only when the summaries are located in detail columns, namely, the table type should be Group Above or Group Left.

Report Style Group

Specifies the default selected style for the four types of components when creating/inserting them via the report/component creation wizard: table, crosstab, chart, and banded object. However, when inserting them into a table or banded object which can bind style, the default selected style type will be Inherit Style instead of the value specified by this option.

All CSS styles in the <install_root>\style directory are available in the drop-down list.

Only display CSS styles in style list

Specifies whether to display only the CSS styles in the style list. This is recommended as XSD files have been deprecated.

Preview

The following are details about options of this category. See the dialog.

Browser

Specifies the browser for previewing reports.

Preview using temporary file

Specifies whether to preview reports that you design in Logi JReport Designer using a temporary file.

Start Logi JReport Server when previewing report

Specifies whether to start Logi JReport Server at the same time when you preview a report.

Start Logi JReport Server when starting Designer

Specifies whether to start Logi JReport Server when Designer is started.

Port

Specifies the port as the TCP port to which Logi JReport Server listens.

Administration Port

Specifies the port used for remote administration.

Run Linked Report

Specifies whether or not to generate the linked reports (not including the detail reports) when viewing the primary reports in Logi JReport Designer or previewing the primary reports in all formats except for Web Report Result and Page Report Result. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.

Catalog

The following are details about options of this category. See the dialog.

Forbid editing data object properties

By default, you are not permitted to change the data property value in the Catalog Manager. Here you can allow editing object property values of data.

Show warning message when modifying formulas

Specifies whether or not to show warning message when the formulas are modified. The message warns you that modifying a certain formula may impact other reports using the same formula.

Warning Level

Specifies the warning level from the following three options:

• Show all warning messages
  If selected, show all the warning messages.
• Show warning message when modifying data objects which are used
  If selected, show warning massage when you modify data objects that are used.
• Do not show warning messages
  If selected, do not show the warning messages at any time.

Sort

Specifies whether or not, and how to sort items in the resource tree. The sort function only applies to resources belonging to the same parent node and of the same type. Real objects in the resource tree instead of logic folder nodes can be sorted.

• Sort ascending
  If selected, the items will be sorted in an ascending order.
• Sort descending
  If selected, the items will be sorted in a descending order.

Merge Catalog Options

Specifies the checking level of merging catalogs when you use Save To to save a report to a directory where a catalog already with the same name exists.

• Identify all differences
  If selected, Logi JReport Designer will check for all the differences between the two catalogs. All the resources of the report will be displayed in the Merge dialog with all the conflicting resources marked.
• Identify critical differences
  If selected, Logi JReport Designer will check for differences which can cause the engine to fail in running a report. All the resources of the report will be displayed in the Merge dialog with any critical conflicting resources marked. As a result, when this option is selected, certain different values may be returned when you run the saved report later.
• Ignore differences
  If selected, the differences between the two catalogs will be shown. If any conflicts exist, they will remain in the resources of the target catalog. As a result, when this option is selected, the saved report might not run later.

Use cached query result

To use cached query result, in the Catalog Manager, right-click on the query (or imported SQL files, stored procedures and UDSs which function as queries) of your report, and choose Create Cached Query Result, then specify the file name with or without an extension and the folder where you want to save the result file. After which, when you view the report, a dialog will be displayed for you to choose the data file with which to get data for the report instead of using the database to get data for the report.

Export to

The options of this category are divided into three sub tabs: HTML, E-mail and Fax.

Layout Precision

Opens the Advanced Export Settings dialog to customize the layout precision for each export format.

HTML

Specifies the preferences for exporting the report results to HTML. See the tab.

Chart

By default, Logi JReport Designer will not display charts in HTML.

• Embed chart as Applet
  Specifies whether the chart will be embedded as an Applet for displaying in Logi JReport Designer.
• Embed chart as GIF file
  Specifies whether the chart will be embedded as a GIF file for displaying in Logi JReport Designer.

File

Specifies whether to convert the report into a single or multiple files.

• Multiple files
  If selected, Logi JReport Designer will convert the report into multiple files and designates a serial number for each HTML page. For example, if a 3-page report is named Sales, Logi JReport Designer will create three files called Sales_1.html, Sales_2.html, and Sales_3.html.
• Single file
  If selected, the report will be exported into one file.

Use HTML data table

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

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.

Absolute font size

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

Relative font size

Specifies whether to generate the report result using a relative font size, which means the font size can be adjusted according to the font size settings in the web browser.

E-mail

Specifies the preference for exporting the report results to E-mail. See the tab.

SMTP Server

Specifies the numeric or named host of the machine where the e-mail server is located.

Port

Specifies the port where the e-mail server runs.

Mail Sender

Specifies the address of the e-mail sender. You must specify an address and make sure that the format of the specified address is valid.

Default Mail Format

Specifies the format with which to send the report result.

• E-mail Result in HTML E-mail Format
  Sends the report result via e-mail to the specified address in HTML format. The report result will be shown in HTML format in the mail body.
• E-mail Result in Plain Text E-mail Format
  Sends the report result via e-mail to the specified address in plain text format. The report result will be shown in plain text format in the mail body with no other information such as color, images and so on.
• Attachment in Logi JReport Result Format
  Sends the report result via e-mail to the specified address with a Logi JReport result file as attachment.
• Attachment in HTML Format
  Sends the report result via e-mail to the specified address with an HTML file as attachment.
• Attachment in PDF Format
  Sends the report result via e-mail to the specified address with a PDF file as attachment.
• Attachment in Excel Format
  Sends the report result via e-mail to the specified address with an Excel file as attachment.
• Attachment in Text Format
  Sends the report result via e-mail to the specified address with a Text file as attachment.
• Attachment in RTF Format
  Sends the report result via e-mail to the specified address with a RTF file as attachment.
• Attachment in XML Format
  Sends the report result via e-mail to the specified address with an XML file as attachment.
• Attachment in PostScript Format
  Sends the report result via e-mail to the specified address with a PostScript file as attachment.

Server requires authentication

This option must be checked if an SMTP Server requires authentication.

Compress Attachment as Java Archive

Specifies whether or not to compress the mail attachment as Java Archive.

Fax

Specifies the preference for exporting the report result to fax. You can specify to export the report result either via a fax machine or a fax server. See the tab.

Fax Machine

Specifies to export the report result via a fax machine.

• Dialing
  Specifies the dialing mode of the fax modem. The options are Pulse or Tone.
• Modem Class
  Specifies the class of the modem. The options are as follows: Class 1, Class 2 or Class 2.0. All are fax protocols. Most modem only support Class 1, so be sure that higher protocols are supported by the modem if Class 2 or Class 2.0 is selected.
• Initialization String
  Initializes the modem. The string should be obtained from the modem manual.
• Flow Control
  Specifies the flow control mode between DTE (Data Terminal Equipment) and DCE (Data Circuit-terminating Equipment). Options are as follows:
  • RtsCts
    Flow control of the hardware.
  • Xon/Xoff
    Flow control of the software.
  • None
    No flow control specified.

    Specifying flow control can help the compressing data function of the modem function better. Using the RtsCts mode is recommended.

• Flow Command
  Specifies the flow command according to the flow control mode. The command should be obtained from the modem manual.
• Port
  Specifies the port number. The port should be obtained from the modem manual.
• Timeout
  Specifies the maximum amount of time for how long the fax should wait for a response from the destination before timing out.
• Retries
  When the line is busy, the report result cannot be faxed, so here you can specify the maximum number of times the modem will retry faxing the report result.

Fax Server

Specifies to export the report result via a fax server.

• Fax Gateway Connector
  Specifies the name of the class implemented by users.
• Server IP
  Specifies the IP address or domain name of the fax server.
• Server Port
  Specifies the port number of the fax server.
• Login ID
  Specifies the ID for the class communicating with fax server.
• Password
  Specifies the password for the class communicating with fax server.
• Fax Sender
  Specifies the user's name that will be shown in the fax server manager.
• Special Parameters
  Specifies some parameters for the fax server.
• Timeout
  Specifies the maximum amount of time that the fax should wait for a response from the destination before timing out.

  Note: For Hylafax Server the value should not be larger than 59 seconds. It is a limitation of Hylafax Server.

• Retries
  Specifies the number of times the modem retries faxing the report result.

Print

The followings are details about options of this category. See the dialog.

Use JDK1.1/JDK1.2/JDK1.4 printing method

Specifies the printing method to print reports.

• JDK1.1
  This method is quick in speed but the printing quality cannot be guaranteed.
• JDK1.2
  This method can give you a satisfactory result, even for a gif file, but it is slow in speed.
• JDK1.4
  Compared with the above two methods, this one is more advanced, and will give you a satisfactory result.

Separate large pages

Specifies whether or not to separate large pages during printing. When you print a report with a report page size which is larger than the print paper size, the report will be printed in multiple pages serially. That is, Logi JReport will automatically separate a large page of a report.

Query Editor

The following are details about options of this category. See the dialog.

Auto join

Specifies the options for auto joins.

• Join on foreign keys
  Specifies to automatically join tables in a query through a reference from Table A to a primary key in Table B. For example, an order form in Table A shows information on purchases that are made by a customer with a primary key of CustomerID. The customer ID # refers to a record in Table B which lists a specific address, phone number, name, and so on for the customer. The CustomerID in Table A is a foreign key because it links the customer's ordering information in Table A to the customer's information in Table B using the CustomerID field.
• Join on primary keys with same names
  Specifies to automatically join tables in a query through a field or a combination of fields that uniquely and specifically identifies a record. For example, the OrderID may be the primary key in a table for Orders and also for Payments.
• Join on same name
  Specifies to automatically join tables in a query through a link between two columns of the same name in two different tables. This often creates many invalid joins such as Amount that appears in both tables.

Pre-join

Specifies the default settings for pre-joins.

• Show warning message when adding tables
  With the pre-join feature, when a table is added to a query, other tables may also need to be added in order to form a per-join path. This checkbox specifies whether the adding table warning message should be displayed.

Preview Result Set

Specifies the default settings for previewing a result set.

• Maximum Number of Records
  Specifies the default total number of records that will be displayed when you previewing a query.
• Maximum Number of Records per Page
  Specifies the default maximum number of records to be displayed on one page when previewing a query.

Additional Options

Specifies the additional options.

• Show table names
  If selected, the table that each column belongs to will be displayed in the criteria panel of the Query Editor.
• Show mapping names
  If selected, the full name of the column in the table will be displayed in the criteria panel of the Query Editor.
• Warn when Cartesian product exists
  Specifies whether or not to display a warning when a Cartesian exists. A Cartesian product is used when tables are added to the query with no join specifications.

  For example, Table A has three values: A, B and C and Table B has three values: 1, 2 and 3. Value A matches value 1, value B matches value 2, and so on. This is a specific match.

  A Cartesian product would have value A matching with 1, 2 and 3, and value B matching with 1, 2 and 3, and so on. Depending on the data values Cartesian products can produce large datasets since each record in Table A matches every record in Table B.

• Automatically add quotation marks on input values
  Enables Logi JReport Designer to add quote marks automatically after a String type value is inputted into the second Expression text box in the AND format when you specify certain criteria for the fields to be retrieved from the database.

Security

The following are details about options of this category, with which you can set one or more user accounts to use Logi JReport Designer. See the dialog.

Start Security Manager

Specifies whether to enable this feature or not. For the first time you check this checkbox, you are prompted to create a user account in the Report Register dialog:

• Administrator
  Specifies the name for the new user account, and at least 4 characters are required.
• Password
  Specifies the password to login, and at least 6 digits are required.
• Confirm Password
  Confirms the password that you specified in the Password text box.
• Submit
  Creates a user account.
• Cancel
  Discards the changes.

Security Manager

Lists all the user accounts.

• Add
  Adds a new user account.
• Remove
  Removes the selected user account.
• Modify
  Modifies the selected user account.

Cache

The following are details about options of this category, with which you can customize the image cache in Logi JReport Designer. See the dialog.

Cache images

Specifies whether or not to enable image cache.

• All used images
  If checked, all the images that are used in reports will be cached.
• Maximum Image Cache Size
  If checked, specify the maximum size for caching images as required. The default value is 5 MB.

Previous Topic  Next Topic