How to create a drill-through hyperlink
1  
2  
1  
2  
Figure 9-9  
3  
1  
2  
3  
4  
Choose OK.
4  
5  
6  
*
*
7  
8  
Choose OK.
Figure 9-10  
The report design displays the hyperlink based on the options you specified.
You can customize the data displayed in the target report and improve performance by using static filter parameters in the target report. For example, instead of generating a target report that shows sales for all states in a country, use parameters to filter report data by state in the target report. The report displays sales details only for the state that the user specifies in the hyperlink builder dialog box, shown in Figure 9-11. Generating a filtered report is typically more efficient than generating a report that displays all the data.
Figure 9-11  
For the value specified in the example shown in Figure 9-11, Actuate BIRT Viewer displays sales details for Nevada, as shown in Figure 9-12.
Figure 9-12  
To set a parameter value based on a data field in the report, you can use the BIRT Studio EasyScript builder to specify the field to use. Complete the following steps:
1  
2  
3  
4  
Figure 9-13  
5  
Figure 9-14  
6  
When a user chooses the hyperlink, the target report uses the specified data field to prompt the user to specify a parameter value to retrieve data to display. For example, to view sales details for Massachusetts, select Massachusetts from the list of values in Parameter. In the target report, make sure that you set a default value for the static filter parameter, if the parameter is required. BIRT Studio does not require you to specify a default value for an optional static filter parameter.

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2