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 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.
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.
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.