thanks for posting this detailed how-to!
Regards,
Eduardo
var parmcount = params["Week"].value.length
var whereclause = "";
if( parmcount > 0 ){
whereclause = " where tblSupplier.Week in ( ";
}
for( i=0; i < parmcount; i++ ){
if( i == 0 ){
whereclause = whereclause + params["Week"].value[x];
}else{
whereclause = whereclause + " , " + params["Week"].value[x];
}
}
if( parmcount > 0 ){
this.queryText = this.queryText + whereclause + " ) ";
}
7. Import these two reports to ReportServer
8. Create a parameter with the same name “Week” on the detailed report (Here also data source parameter has been used)
9. Run "Summary Report" and it will drill down to detailed report with Week value as selected.
we are working in a how- to for drill option with BIRT reports. For now, please take a look at this document: http://www2.datenwerke.net/rsupdate/drill_through.pdf
It should help you with this.
Thanks @jeffrozica for providing us with this how-to.
Regards,
Eduardo
Steps followed:
1. Created "Summary Report" with "Week" and "Quantity" (Table View)
2. Create a report parameter as "WeekRptParameter" and Set the hyperlink as below.
http://server_ip/reportserver/#reportex … &v:preview
3. Created "Detailed Report" with "Week", "Date" and "Quantity"
When click on one week value on "Summary Report", it should drill down to "Detailed Report" with Date values (should be filtered based on selected week value). These reports were built on Eclipse BIRT
4. import 2 reports to ReportServer
5. Create a parameter "WeekRptParameter" on "Detailed Report"
5. Run "Summary Report" and it will drill down to detailed report with Week value = 44 as we have set it to constant.
Please guide us how to set it dynamic based on what we have selected on Summary Report. We have read about backlink, but unable to understand it.
Please advice us with some example according to our scenario.
Thanks.
]]>