Eclipse Community Forums: BIRT » WANTED: Drill Down Tutorial

Home » Archived » BIRT » WANTED: Drill Down Tutorial

WANTED: Drill Down Tutorial [message #1053823]

Tue, 07 May 2013 14:09

Eclipse User

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

Eclipse User

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

Eclipse User

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

Eclipse User

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 580 times)

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

Fri, 20 October 2017 15:37

Eclipse User

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.

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

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 09:32:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter