Advanced Run

The Advanced Run dialog box is used to run a report in Advanced mode.

There are the following tabs in this dialog box: General, Parameter, Format, Archive and Duration.

Back

Goes back to the left tab.

Next

Goes to the right tab.

Finish

Applies the settings.

Cancel

Closes the dialog box and discards any changes.

Help

Displays the help document about this feature.

General

This tab allows you to specify the general information about a report.

Advanced Run dialog - General tab

Select Report Tabs

The section is available for page reports only. It allows you to specify the report tabs which you want to run. The selected report tabs will be run in the list order. If the page report has only one report tab, it is selected by default.

Moves the specified report tab one step up.
Moves the specified report tab one step down.

Select Dynamic Connection

The section is available when there are multiple dynamic connections for the current log-in user. It allows you to specify a dynamic connection.

Data Source
Displays the data source name in the catalog.
Connection Name
Displays the dynamic connection name.
Connection
Specifies a dynamic connection from the drop-down list.
Connection Properties
Shows the information of the selected dynamic connection, which is read only.

Report Information

Specifies other report information.

Report
Lists the report information.
Catalog
Lists the catalog information. Unavailable to shared reports.
- Select Another Catalog
  Specifies another catalog for the report in the Select Another Catalog dialog box.
Report Version
Specifies the report version. Unavailable to shared reports.
Catalog Version
Specifies the catalog version. Unavailable to shared reports.
Priority
Specifies a priority level to the report running task. The priority levels are from 1 to 10 in ascending order of lowest priority to highest priority. This property is available to administrators. By default this property is ignored unless server.properties is modified to set queue.policy not equal to 0.

Parameter

This tab allows you to specify the parameter values if any to run the report.

Advanced Run dialog - Parameter tab

Enter Parameters

Lists all the parameters used by the report. Edit the values according to your requirement.

If no parameter is used in the report, Report Server displays "No Parameter Needed" here.

Use Saved Values

If it is available, you can select the previously saved parameter values to apply to the report and save parameter values for reuse later.

Save as default

Saves current parameter values as the default values for the report. Not available when Enable Setting Default Parameter Values For the corresponding report type is unselected in the server profile.

This option is a user-report level setting. It is an action and takes effect after the task is submitted. Its initial status is always unselected.

Format

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

Advanced Run dialog - Format tab

Select Format

Specifies the format of the report result.

Select Format
Specifies the format in which the report result will be and the properties of the selected format. The format can be one of the following:

Advanced

Specifies some advanced format settings.

Enable Style Group
If a style group has been specified via the Override Style Group option in the server profile, this option gets selected and the specified default style group is selected in the Style Group drop-down list by default. You can also choose another style group from the Style Group drop-down list to run the selected page report tabs or web report.
When the <No Style> item is selected in the Override Style Group drop-down list, this option is unselected by default and the style group property of the page report tab or web report for this format that is predefined in Logi Report Designer will be used to run the selected page report tabs or web report.
Enable Converting Encoding
Specifies whether to enable the conversion of encoding. If the option is selected, 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 the option is selected, the Using Language drop-down list will be displayed for you to choose a language. 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 the option is selected, the DB user and password defined in the catalog will be used.
- Use the DB User
  Select this option and you can then specify another DB user and password instead of the one defined in the catalog.
Use User Defined Default On-screen Filter Values
Applies the default on-screen filter values specified to the report for the user. The option is unavailable when Enable Setting Default On-screen Filter Values For the corresponding report type is not selected in the server profile.
Add TaskListener to be Invoked
Enables you to call a Java application before/after the report runs so as to obtain information about the report task. Enabled only when the format is not specified to Page Report or Web Report.

Duration

This tab is available only when you have enabled the task-level timeout mechanism. In this tab, you can specify a time duration for a task, and ask Logi Report Server to cancel the task or to notify you or someone else of the task status via e-mail if the task has not yet finished running when the task duration is up.

Advanced Run dialog - Duration tab

The following are the available options:

Timeout

Specifies the time duration for the task.

Notify by e-mail after the specified time

Sends an e-mail about the task information when the specified time is up.

Mail To
Specifies the e-mail address of the recipient.

Cancel the task after the specified time

Cancels the running task when the specified time is up.

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.

View Mode

Specifies which Web Report Studio mode is applied to run the report.

View Mode
If selected, Web Report Studio will run in View Mode by default. You can switch to Edit Mode if the link is available.
View Mode Only
If selected, Web Report Studio will run in View Mode only. You are not able to switch the mode.
Edit Mode
If selected, Web Report Studio will run in Edit Mode by default. You can switch to View Mode if the link is available. The option is available only when you have the Edit permission on the report.

Page Report

Runs a page report in Page Report Studio.

Resolution

View Mode

Specifies which Page Report Studio mode is applied to run the report.

Basic View
If selected, Page Report Studio will run in Basic View by default. You can switch to Interactive View if the link is available.
Basic View Only
If selected, Page Report Studio will run in Basic View only. Users are not able to switch the view.
Interactive View
If selected, Page Report Studio will run in Interactive View by default. You can switch to Basic View if the link is available. The option is available only when you have the Edit permission on the report.

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 result has 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 result in the My Tasks > Background Tasks table.

The setting of the option takes effect when Enable Background Task for Reports in the server profile is selected.

HTML

No Margin

Removes the margins you originally set while designing the report.

Multiple Files

Generates the report result to multiple HTML files. Logi Report designates a serial number for each HTML page. For example, if you named a 3-page report as "sales", Logi Report 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 the option is selected, there will be no hyperlinks for navigating previous and next pages on the navigation bar of the generated HTML file.
No Page Number
If the option is selected, 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 the option is selected, the accessibility attributes defined for the report elements via the Report Inspector will be generated to the HTML result which is Section 508 compliant. For more information, select Making HTML and PDF Report Results and Server Console Accessible.

When Section 508 Compliant Output is selected, the Use HTML Data Table and Relative Font Size options will be selected 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.

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 Logi Report 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 specify whether or not to generate the linked reports (not including the detail reports) in the result. If you are only interested in the primary report, leave this option unselected. Generating linked reports at the same time will cause performance issue, especially when the linked reports contain a large amount of data.

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, Logi Report 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, Logi Report 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 the option is selected, you can then select the Settings button to configure the encrypt settings in the Encrypt dialog box.

Sign

Specifies whether to add the digital sign to the PDF file. If the option is selected, you can then select the Settings button to configure the sign settings in the Sign dialog box.

Run Linked Report

Accessible PDF

Generates the report result as an accessible PDF file. For more information, select Making HTML and PDF Report Results and Server Console Accessible.

Zoom

Specifies the zooming of the report content in the exported PDF file. You can select an item from the drop-down list or type a percentage in the text box. A valid percentage is greater than 0 and no larger than 6400% (you can type the value with or without the percent sign). Any invalid input will be treated as Default.

Default - It means no zoom setting. After the PDF file is opened in the Adobe Acrobat, the zoom setting follows that in the Adobe.
Actual Size - The report content remains its original size. It is same as 100%.
Fit Page - The report content in a page is scaled to fit the entire page within the window both horizontally and vertically. If the required horizontal and vertical scale ratios are different, the smaller of the two is used.
Fit Width - The report content in a page is scaled to fit the width of the page within the window.
Fit Height - The report content in a page is scaled to fit the height of the page within the window.
Fit Visible - The report content in a page is scaled to fit the width of its bounding box within the window.

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.

Auto Format
If the option is selected, it is up to Logi Report to determine whether to apply Report Format or Column Format according to the objects in the report. If the report contains crosstabs or tables, Column Format will be used; otherwise it is Report Format. This option is selected by default.
Report Format
If the option is selected, Logi Report 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 the option is selected, the calculation method used for all components' row/column values in the report will be decided by the Columned property value of the report when exporting. This method is recommended when you want to actively use the result in Excel such as filtering and sorting.
Data Format
If the option is selected, 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

Select 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 specify whether or not to generate the linked reports (not including the detail reports) in the result. If you are only interested in the primary report, leave this option unselected. Generating linked reports at the same time will cause performance issue, especially when the linked reports contain a large amount of data.

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 the option is selected, when a cell in the generated CSV Text file has no value, value of the previous cell in the same column will be used.
Custom Delimiter
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
Specifies to use a comma to separate the fields.

Horizontal Density

Specifies the value for each unit of the horizontal density between columns, which is an integer. 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 Logi Report.

Vertical Density

Specifies the value for each unit of the vertical density between columns, which is an integer. 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 Logi Report.

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 one of the values of Horizontal/Vertical Density is greater than 0 and the other one is less than 0, the value greater than 0 will be applied and the other one will be specified by Logi Report.
- 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 Logi Report.
- If the values of Vertical Density and Horizontal Density are both less than 1, these densities will be specified by Logi Report.

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 the option is selected, 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 the option is selected, 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 the option is selected, only the Unix End-of-line character <lf> will be used.

Run Linked Report

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

Tip: Microsoft Word Document limits the maximum page size in Word Print Layout to 22 inches. This may result in that when you export a report with many columns in the RTF format and then view it in Microsoft Word Document the columns on the right get lost. If this happens you can switch to Web Layout. If still not working, try a latest version of Microsoft Word Document.

XML

Only Data

If the option is selected, 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 the option is unselected, 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

PostScript

No Margin

Removes the margins you originally set while designing the report.

Run Linked Report

Previous Topic Next Topic