Hide Details

nuno

Hello,


Is it possibel, to hide detail rows in a table and show them after a click on the headline? I only found the function to hide the row static.


I have a report which shows invoices. One SQL-Query/Table, for each Group (>20 Groups, i.e.: North, West, etc.) with a sum in the headline. First, the User want see an overview, later drill down to the invoices of each group. Link to an other page is no problem, but much work and double to code.


Overview:

---

North 3000
South 4000
West 1000


Detail:

---

North 3000
.Company A 1000
.Company B 3000
South 4000
West 1000


Kind regards

averma

Hi Nuno,
There are a couple of ways you can achieve this:
1. Using drill down reports - In this approach you could hide the group details and set up a hyperlink to do a drill down on the summary column that display the details in a separate window (You don't need to write any code for this since this functionality is available within the designer)
2. Use scripting to write your own code to handle the button click event to pull the detailed data and display in a separate dialog or pop-up.


Ashwini