Our Birt report contains a link to a sub-report but I am having some problems configuring this nicely in Birt / Report Server and was wondering about cleaner approaches.
Option 1: Using a Drill-through hyperlink in Birt
In Report Server, both reports are imported but when I execute the master report, the link in the report doesn’t render the sub-report (doesn’t seem to point to a valid path). After reading a few other posts on the forum and this blog (http://blog.datenwerke.net/2013/05/calling-reports-via-url-drill-downs.html), am I correct in thinking that ReportServer does not support the use of Birt’s drill-through hyperlinks?
Option 2: Using a URI hyperlink in Birt
In the Birt report, set the URI hyperlink as follows (in this case, there is 1 parameter being sent to the sub-report, and the value is coming from the selected row in the master report):
"https://myhostname/reportserver/reportserver/reportexport?key=HQ_CustImgRtrvl2&format=pdf&p_RP_IMGID="+row["IMGID"]
This works reasonably well, but I don’t want to have to hardcode the hostname and the report format in Birt like I’ve done above. For the format, it would be nice for the sub-report to render in the same format as the master report.
I think I could add parameters in ReportServer to send the hostname and format to the master report and then use them in the hyperlink URI as " params[“myParamName”] ", but is there a better way to accomplish this?
Any tips would be appreciated!