Skip to Content
0
Former Member
Feb 27, 2009 at 02:50 PM

hierarchy - drill from master to detail

26 Views

Hi,

BOXI 3.1 on RHEL 5 connecting to MySQL 5

I'm keen to test a hierachial report.

OUr users want to have a report that displays master or summary info and then they want the ability to srill down and see detailed info associated with that same record.

Have a look at the link below.

1st screenshot is how I set up the hierachy - custom hierarchy

2nd screenshot is of a test report (just 1 record for simplicity)

I want ot get to the stage where the green fields on the right are hidden when the report is first run and then only by the user either pressing an expand button or drilling in to the individual master record itself can they see these hidden detailed values.

Any suggestions welcome

[http://docs.google.com/Doc?id=dfr8cvrq_184dph4pkgc|http://docs.google.com/Doc?id=dfr8cvrq_184dph4pkgc]