Previous Topic  Next Topic

Creating links with JHyperLink

JHyperLink can be used to create hyperlinks in page reports. This topic shows you two specific examples about using JHyperLink.

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

• Example 1: Building Hyperlinks by using JHyperLink
• Example 2: Linking Reports using Parameters by using JHyperLink

Example 1: Building Hyperlinks by using JHyperLink

Sometimes you have a number of reports that contain different views of the same data. You may want to build a summary report to organize these reports together. For example, Report A is Summary Information for Orders, while Report B is an Invoice Report showing the detail line items of the order. When you select on the Order ID in Report A, it will go to the detail page of that order in Report B. With this hyperlink feature, you can build hyperlinks among reports. In addition, you can also insert any hyperlink to be invoked. In any case, a web browser will be displayed to view the specified pages.

1. Start Logi JReport Designer and open the report in which you want to build a hyperlink.
2. Select Insert > UDO to display the Insert UDO dialog.
3. Select JHyperLink from the UDO drop-down list, and then select OK. You will then be able to insert a hyperlink into the report.

   

4. Keep the JHyperLink focused, and then go to the Report Inspector.
5. Input http://localhost:8888 in the value cell of the URL property as the Logi JReport Server address, make sure the Executer Class Name value is jet.udos.IEExecuter, and then type Logi JReport Server in the Display Value property value cell as the display name of the hyperlink.
6. Insert another hyperlink using the same way and define its properties in the Report Inspector as follows:
   • URL: http://www.jinfonet.com
   • Executer Class Name: jet.udos.IEExecuter (the default value)
   • Display Value: Website

   Two hyperlinks have been successfully built into the report.

7. In view mode, select the Logi JReport Server hyperlink that you just made. It will bring out a browser session to connect with Logi JReport Server. Make sure that you have launched Logi JReport Server and that the URL corresponds with your server configuration.
8. Select the Website hyperlink. You will then see the http://www.jinfonet.com home page in a web browser.

Example 2: Linking Reports using Parameters by using JHyperLink

JHyperLink can be used to link reports similar to master and detail reports to show related information, such as Order detail to higher level Year to Date Sales. You can use the JHyperLink object to control the URL to show the information in the linked reports on Logi JReport Server. It is similar to master/detail but does not have the ability to navigate through the detail and return to the master. The key to using JHyperlink is learning how to use URLs to call page reports. .For additional information, see Running Reports via URL in the Logi JReport Server User's Guide.

For how to use JHyperLink to link reports using a URL, Logi JReport Designer provides an example for your better understanding.

All the needed materials for this example, including the reports and catalog are in <install_root>\help\samples\UDODemo.

1. In Logi JReport Designer, open the catalog for this example Demo.cat in <install_root>\help\samples\UDODemo\reports.
2. Select one of the existing reports and ensure the reports in this catalog can run. If there is a problem, open the Catalog Manager, highlight the connection node, and in the Properties sheet, modify the value of the URL property to connect to the demo database, which is jdbc:hsqldb:<install_root>\help\samples\UDODemo\db\demo.

Linking the master report to the detail report

Formulas will be used to control the property values URL and Display Value of JHyperLink to make it link the master and detail reports.

1. Open the report that contains the master report - mainreport.cls.

   A JHyperLink is inserted in the Detail panel of the report. The URL and Display Value property values of the UDO are as follows:

   • URL: Controlled by the formula linkToSalesYearly, which is defined as follows:

     "http://localhost:8888/jrserver?jrs.cmd=jrs.web_vw&jrs.catalog=/USERFOLDERPATH/admin/Demo.cat&jrs.report=/USERFOLDERPATH/admin/SalesPerformancebyYear.cls&jrs.result_type=8&jrs.param$pEmployeeID="+@"Employee_Employee ID"

     This URL value enables you to drill down to the detail report and also make a link for this detail report on the top of the page for you to drill up and down.

   • Display Value: Determined by the DBField EmployeeName to show the Employee Name in the master report.
2. Open the report that contains the detail report SalesPerformancebyYear.cls.

   In the GroupHeader panel, the value of Total is a JHyperLink, whose property values URL and Display Value are both controlled by formulas.

   • URL: Controlled by the formula linkToQuarter, which is defined as follows:

     "http://localhost:8888/jrserver?jrs.cmd=jrs.web_vw&jrs.catalog=/USERFOLDERPATH/admin/Demo.cat&jrs.report=/USERFOLDERPATH/admin/SalesYearPerformancebyQuarter.cls&jrs.result_type=8&jrs.param$pEmployeeID="+@"Employee_Employee ID"+"&jrs.param$pYear="+@getYear;

     Where, the URL is used to access the detail report SalesYearPerformancebyQuarter.cls, and the records of the detail report are filtered by the parameters pEmployeeID and pYear.

   • Display Value: Controlled by the formula getSalesByYear, which is defined as follows:

     "$"+ToText(@Sum_TotalSales0)

     This formula returns the total sales amount for the year.

   • Target: The options are self, parent, top and blank. Use self to replace the current report with the linked report. Use blank if you want to open a new browser tab so you can return to the master report window.

Running the reports on Logi JReport Server

This example requires you to access the report by URL, you can drill down through the reports. To do this:

1. Start Logi JReport Server.
2. Publish the reports and catalog to Logi JReport Server as admin into the root level of My Reports.
3. Run the master report mainreport.cls in Page Report Studio.

   

4. Select any name in the Employee Name column, and the year's performance of the employee will be displayed.

   

5. Select the Total number, and it will drill down to the next detail report.

   

Previous Topic  Next Topic