EmbededReports
Please note: Subreports feature has been disabled because the implementation was dependant on vaadin addon requiring widgetset recompilation.
1. Add links to sub reports.
In this example we will create a link list of user names that lead to detailed report created in previous example. Query returning users and their report counts:
select username, count(username)
from vries_report_order
group by username
Add Table component. Insert Text field containing reference to user name in a table detail cell.
Now right click on the Text field and choose Hyperlink. Set up Hyperlink type to Rererence and input following expression into Hyperlink references:
"drilldown?reportName=user_detail_activity"
+ "&allowRefresh=true"
+ "&allowedFormats=XLS"
+ "&username=" + $F{username}
drilldown is a special command for Aperte Reports to handle subreports. After the question mark you should give the reportName and parameters separated by ampersands. Dynamic values ??can be passed beyond the quote as in the example.
2. Publish report and invoke subreports.
Add this report to Dashboard portlet. Now when you click user name link, portlet content will be replaced by a new report. It is possible to return from subreport when you clicking Back button.
