Lesson 3: Running Reports
This lesson describes how to run reports from the Logi JReport Server console. This lesson represents one way that end users could access and run published reports. Reports that are embedded in a Java application would not be accessed from the server console, but instead from the Java application. The interaction with the report itself however would be the same as described here.
The reports you view in this lesson are in the JinfonetGourmetJava folder, which is the folder you published them to in Lesson 2 > Task 1 of this track. Before you can view the reports, make sure you have the Execute and/or Edit permissions on them.
This lesson contains the following tasks:
- Task 1: Directly Run a Report
- Task 2: Run a Parameter-Based Report
- Task 3: Run a report in Advanced Mode
Direct running of reports is to use the default format setting to view the report result. By default, page reports (.cls) are opened in Page Report Studio and web reports (.wls) in Web Report Studio.
In this task, we will run a page report in the JinfonetGourmetJava folder as an example:
- In the Resources page of the server console, go to the Public Reports > JinfonetGourmetJava folder.
- Select the ShipmentDetailsbyCustomer.cls link to run the report.
Page Report Studio then appears in a separate web browser window, with the report result for the ShipmentDetails report tab in the page report:
When you directly run a report, if the report contains parameters, you will be asked to specify the parameter values. See the next task for details.
As you saw in the Creating a Parameter-based Report lesson, parameter-driven reports are another way to have a dynamic report. They allow the end users to specify the data that they want to see before the query is issued to the database. By only selecting the data that the report needs, the query is more efficient.
When a parameter-based report is run, Logi JReport Server automatically displays the Enter Parameter Values dialog to prompt the user for the expected values. Default values, if included in the report template definition, are also displayed.
To run the parameter-based report:
- In the JinfonetGourmetJava folder, select the OrderListbyDate_Parameter.cls link.
A new web browser window opens for you to enter the parameter values. The report template includes start date of May 1, 2016 and end date of June 1, 2016 as default. You can select Submit button to admit these defaults, or you can type new values to view the report. Here we use the default values.
- The requested report is displayed showing only order details from May 1, 2016 8:00:00 AM to June 1, 2016 8:00:00 AM.
The Advanced Run command allows you to specify additional properties when running a report, for example you can specify a different report format instead of the default one, which can be one of the following: HTML, PDF, Text, Excel, Postscript, Rich Text Format (RTF) and XML. In this task we will run the report as PDF format.
- In the JinfonetGourmetJava folder, put the mouse pointer over the CustomerContactCard.cls report row, then select the Advanced Run button on the floating toolbar.
- In the Advanced Run dialog, select the Format tab and select PDF from the Select Format drop-down list, as shown below:
In this task, the additional options in the Advanced Run page are not used. However these options can be quite useful in real reporting scenarios. For example, you can specify database credentials under which the query should execute, or apply a style group so that the report has a different look.
- Select the Finish button. According to your Adobe configuration, the report is displayed as a PDF file in your web browser, or saved into the default download folder of your browser.