Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » WANTED: Drill Down Tutorial
WANTED: Drill Down Tutorial [message #1053823] Tue, 07 May 2013 14:09 Go to next message
Marc Horvath is currently offline Marc Horvath
Messages: 6
Registered: May 2013
Junior Member
Hi guys,

I'm looking for a tutorial on how to create a report that contains a table of summary information where when I click on any line in the table it expands to show me the details that went into that line. I believe this is a drill down. I've found example reports but I'm looking for a guide on how to create one not just an example. The example I've already found works but I don't know how pick it apart and learn from it. I hope there's a step by step tutorial somewhere on how to do something like this.

Thanks in advance,
Marc
marc@andrewsandwatson.com
Re: WANTED: Drill Down Tutorial [message #1053857 is a reply to message #1053823] Tue, 07 May 2013 17:35 Go to previous messageGo to next message
Kristopher Clark is currently offline Kristopher Clark
Messages: 107
Registered: January 2013
Senior Member
Check out this link it's a flash tutorial showing how to create a drill through report that might be useful. Smile
Re: WANTED: Drill Down Tutorial [message #1057725 is a reply to message #1053857] Wed, 08 May 2013 09:23 Go to previous messageGo to next message
Marc Horvath is currently offline Marc Horvath
Messages: 6
Registered: May 2013
Junior Member
Hi Krisopher,

Thanks for your reply and the link. The only problem is the example shows how to link one report, a master list, to a second report, a detail list. I want to create one report where in the master list I can expand any line item and display the details that support it. I know it can be done because I've seen an example of it. However, I have no idea how to create it. I'm looking for a 'how to' guide on how that can be done.
Re: WANTED: Drill Down Tutorial [message #1057920 is a reply to message #1057725] Thu, 09 May 2013 15:16 Go to previous message
Kristopher Clark is currently offline Kristopher Clark
Messages: 107
Registered: January 2013
Senior Member
I've attached an example on how you can do this using drill-through links.

First I created a table and grouped on the customer name. I then removed the customer name from the group detail row leaving it only in the group header and added a hidden parameter called "customer".

Next I put payment date and amount in the detail row bellow the group header and made that entire row invisible from properties > visibility. The key to making these expand and collapse is the expression I used for the visibility of that row.

if(row["CUSTOMERNAME"]==params["customer"].value) {
  false;
}else{
  true;
}


Then I created the hyperlink by selecting "customer name" from the header row > hyperlink. I selected itself as the target report. To pass the value of the customer name back to itself as a parameter you'll need to click "Add", choose "customer" as the parameter and row["CUSTOMERNAME"] as the value.

This will pass the value of whatever you click on back to itself through that hidden parameter. Finally you'll need to select "same frame" in step 4 of the hyperlink UI.

Now if you run the report you should be able to click on any customer name and it will expand the payments they have made. When you click on another customer the old one should close and you should be left with the new information.

Let me know if this helps!
Previous Topic:Spanning Columns Across Pages
Next Topic:Where is the BIRT 4.2 API?
Goto Forum:
  


Current Time: Sat Apr 19 21:39:44 EDT 2014

Powered by FUDForum. Page generated in 0.01724 seconds