Eclipse Community Forums: BIRT » WANTED: Drill Down Tutorial

Help

Home

Home » Eclipse Projects » BIRT » WANTED: Drill Down Tutorial

Show: Today's Messages :: Show Polls :: Message Navigator

WANTED: Drill Down Tutorial [message #1053823]

Tue, 07 May 2013 18:09

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

Report message to a moderator

Re: WANTED: Drill Down Tutorial [message #1053857 is a reply to message #1053823]

Tue, 07 May 2013 21:35

Kristopher Clark

Messages: 130
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

Report message to a moderator

Re: WANTED: Drill Down Tutorial [message #1057725 is a reply to message #1053857]

Wed, 08 May 2013 13:23

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.

Report message to a moderator

Re: WANTED: Drill Down Tutorial [message #1057920 is a reply to message #1057725]

Thu, 09 May 2013 19:16

Kristopher Clark

Messages: 130
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!

Attachment: expand_details.rptdesign
(Size: 16.32KB, Downloaded 311 times)

Report message to a moderator

Re: WANTED: Drill Down Tutorial [message #1774885 is a reply to message #1057920]

Fri, 20 October 2017 19:37

Bill Yee

Messages: 1
Registered: October 2017

Junior Member

This thread was very useful for what I'm trying to do.

But... what would I need to change if I want expanded customers to stay expanded if I click another customer and re-clicked customers to close?

I'd really appreciate any assistance.

Report message to a moderator

Previous Topic:	BIRT - Merging Data from 2 Rows
Next Topic:	Chart from a crosstab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 16 16:29:17 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter