#1 2018-12-10 13:52:05

Nayana
Member
Registered: 2018-11-15
Posts: 62

Integration of BIRT with Drill Down Option

We tried to integrate BIRT report with Drill down option with ReportServer, but it didn't work properly on ReportServer.

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.

Last edited by Nayana (2018-12-11 04:38:06)


Thanks & Regards
Nayana

Offline

#2 2018-12-12 10:40:46

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,130
Website

Re: Integration of BIRT with Drill Down Option

Hi Nayana,

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

Offline

#3 2018-12-13 07:27:35

Nayana
Member
Registered: 2018-11-15
Posts: 62

Re: Integration of BIRT with Drill Down Option

Thanks a lot. We got some guidelines from that pdf also. For our scenario, that flow does not work properly. But finally we were able to get it done and i have given them step by step for the use of anyone who is struggling with this option. Hope this may helpful for beginners.
1.    Created "Summary Report" with "Week" and "Quantity" (Table View)
2.    Create a report parameter for URL (Make this hidden) and put the default value as,
http://server_ip/reportserver/#reportexec/id:82904&v:preview
3.    Click on “Week” in the summary report and go to “Properties” window. Put “Hyperlink” as below.
params["pRsUrl"].value+"&p_Week:"+row["Week"]
4.    Create a Detailed report on BIRT with "Week", "Date" and "Quantity"
5.     Create a report parameter for Week in detailed report. (Here we have selected Dynamic and allowed multiple values and referred to the database relevant field.
6.    The following Script will be added on the dataset (Before Open) to enable the multiple selection (Script can be changed to single selection also as for this scenario single selection would be enough)

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.

Last edited by Nayana (2018-12-13 07:31:24)


Thanks & Regards
Nayana

Offline

#4 2018-12-13 07:29:47

Nayana
Member
Registered: 2018-11-15
Posts: 62

Re: Integration of BIRT with Drill Down Option

Please replace [x] to i with square brackets as I was not allowed to post it with that

Last edited by Nayana (2018-12-13 07:32:28)


Thanks & Regards
Nayana

Offline

#5 2018-12-13 08:02:09

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,130
Website

Re: Integration of BIRT with Drill Down Option

Hi Nayana,

thanks for posting this detailed how-to!

Regards,
Eduardo

Offline

#6 2018-12-13 09:09:09

Nayana
Member
Registered: 2018-11-15
Posts: 62

Re: Integration of BIRT with Drill Down Option

You are most welcome


Thanks & Regards
Nayana

Offline

Board footer

Powered by FluxBB