Previous Topic  Next Topic

Running Reports

This topic introduces how to run reports directly, in Advanced mode, and in background mode. If you know the default format for viewing reports and this format is what you expect, use direct running. If you would like a different view format or to customize some other information such as the running priority, how to save the result, the expiration time and so on, use advanced running.

Note: To run reports in public folders in the server resource tree, you must have the Execute and/or Edit permissions on the reports and the Visible and Read permissions on the catalogs that the reports use. For more information about permissions, see Managing Permissions.

Below is a list of the sections covered in this topic:

• Running Reports Directly
• Running Reports in Advanced Mode
• Running Page Reports in Background Mode

Running Reports Directly

Direct running reports is to use the default format setting to view the report result.

If the reports are created on Logi JReport Server, the default format is controlled by the Default Format for Viewing Report option in the server profile. By default, this option is set to Web/Page Studio, which means that page reports (.cls) are opened in Page Report Studio and web reports (.wls) in Web Report Studio.

If the reports are edited using Logi JReport Designer, the default format is controlled by the Default Format for Viewing Report property in the Report Inspector. If this property is set to <Server Setting>, the viewing format will be determined by the above setting on server. For page reports this property is available to each report tab in the reports, therefore when a page report contains multiple report tabs and these report tabs have different default format settings, for example, report tab 1 is Page Report, tab 2 HTML and tab 3 Excel, there will be different direct running results, depending on which report tab is the last-time focused tab in the page report when the page report is saved at report design time. If it is report tab 1, all the three tabs in the page report will be opened in Page Report Studio. If it is report tab 2 or 3, only tab 2 or 3 will be displayed in the specified format, and this applies to all the other formats except Page Report.

You can run a report directly from the server resource tree in the Logi JReport Server console by taking any of the following ways:

• Selecting the report name
  To use this way to run a report saved in the Public Report folder, you need to have the Execute permission on the report so that the report name can be shown with hyperlink when you move the mouse pointer on the report row.

  Selecting the report name runs the report in the default format (if the report contains parameters, you need to specify the parameter values). When the default format for viewing report is Web/Page Studio, which studio mode will be applied to run the report is decided by the Default View for Page Report Studio/Default Mode for Web Report Studio option in the server profile. However if the default view/mode is Interactive View/Edit Mode but you do not have the Edit permission on the report, you will fail to run the report and instead get an error message.

• Using the Run option
  To use this way to run a report saved in the Public Report folder, you need to have the Execute permission on the report so that the Run option can be available.

  Do any of the following:

  • Put the mouse pointer over the report row and select the Run button on the floating toolbar.
  • Select the report row, right-click in the report row and select Run from the shortcut menu.
  • Select the report row and select Run > Run on the task bar of the Resources page.

  If the report contains parameters, you will be prompted to specify the parameter values. Then the report will be displayed in the default format. When the default format for viewing report is Web/Page Studio, page report will be opened in Basic View of Page Report Studio and web report in View Mode of Web Report Studio.

  You can also use the Run option to run multiple reports at a time. To do this, check the checkboxes ahead of the required reports and select Run > Run on the task bar or right-click in any report row and select Run from the shortcut menu. If the selected reports contain parameters, the parameter dialog for each report will appear for you to specify the parameter values. After that the reports will be displayed one by one in the default format.

• Using the Edit option
  To use this way to run a report saved in the Public Report folder, you need to have the Edit permission on the report so that the Edit option can be available. For a shared report, the Allow Edit property should also be enabled.

  Do any of the following:

  • Put the mouse pointer over the report row and select the Edit button on the floating toolbar.
  • Select the report row, right-click in the report row and select Edit from the shortcut menu.
  • Select the report row and select Run > Edit on the task bar of the Resources page.

  If the report contains parameters, you will be prompted to specify the parameter values. Then the report will be displayed in the default format. When the default format for viewing report is Web/Page Studio, the report will be opened in Interactive View of Page Report Studio or Edit Mode of Web Report Studio.

Running Reports in Advanced Mode

To run reports saved in a public folder in Advanced mode, you need to have the Execute permission on the reports.

1. In the server resource tree in the Logi JReport Server console, browse to the report you want to run.
2. Do either of the following to open the Advanced Run dialog.
   • Put the mouse pointer over the report row and select the Advanced Run button on the floating toolbar.
   • Select the report row, right-click in the row and select Advanced Run from the shortcut menu.
   • Select the report row and click Run > Advanced Run on the task bar of the Resources page.
3. In the General tab,

   

   1. For a page report, select the report tabs in the page report you want to run. The report tabs will run in the list order. You can change the order of the report tabs by selecting and . However if you choose to run the page report in the Page Report format in the Format tab, the unselected report tabs will also be run.
   2. If there are multiple dynamic connections available, expand the Select Dynamic Connection section and select a connection from the drop-down list. Select Connection Properties to view the connection information if needed.
   3. Expand the Report Information section, select Select Another Catalog to specify another catalog for the report if required, and select the report version and catalog version from the corresponding drop-down lists (the catalog and report/catalog version cannot be changed if the report is a shared report).
   4. Assign a priority to the task from the Priority drop-down list. The Priority property is available to administrators only and the priority levels are from 1 to 10 in ascending order of lowest priority to highest priority (by default this property is ignored unless server.properties is modified to set queue.policy not equal to 0).
4. In the Parameter tab, specify the parameter values if the report has parameters.
5. In the Format tab,

   

   1. Choose a format to view the report result and set the properties of the selected format. When HTML is selected, the names of page navigation links in the HTML results such as First, Previous, Next, and Last can be localized according to your requirements. For details, refer to Localizing Page Navigation Links in HTML Report Outputs.
   2. Expand the Advanced section.
   3. Specify the style group for the report.
   4. Check the Enable Converting Encoding option and specify the encoding before and after converting from the corresponding drop-down lists.
   5. If the report is defined with NLS, check Enable NLS then specify a language to display the report contents in.
   6. Define the encoding for the report by selecting from the Encoding drop-down list.
   7. Specify the DB user and password with which to connect with the data source. You can either use the default ones defined in the catalog or specify another DB user and password.
   8. The default on-screen filter values you have saved in the report will be automatically used to run the report. If you do not want to apply the filter conditions, uncheck Use User-Defined Default On-screen Filter Values.
   9. When the selected format is any format other than Page Report or Web Report, check the Add TaskListener to be Invoked option to call a Java application before/after the report runs so as to obtain information about the report task (for details, see Applying TaskListener).
6. In the Archive tab, check the Auto Archive Properties checkbox, then specify where to generate the report result version and the archive policy.

   

7. If the Duration tab is available, specify a time duration for the task, and ask Logi JReport 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. For detailed information, see Task-level Timeout for Advanced Run and Schedule Tasks.
8. Select Finish to run the report.

Running Page Reports in Background Mode

When you run a page report in Page Report Studio, if the report contains a large amount of data, you need to wait several minutes before the report result is displayed, and during this period you should make sure the report processing page is not closed. This may bring you some inconvenience, therefore Logi JReport provides you the Background and Cancel options on the report processing bar to allow you switch the report to run in background mode or cancel it from running.

By setting the Background Mode Timeout option in the Page Report Studio profile, you can also make page reports run automatically in background mode after a specified time period. Then when a report runs in Page Report Studio and the result has not yet been generated after the specified time, it will be automatically switched to run in background mode.

When a page report completes running in background, it will be listed in the Background Tasks table of the My Tasks page. You can open the report result by selecting the Page Report link in the table.

Previous Topic  Next Topic