Heirarchical Drill Down Reports

[Former Member]

I went to a contract interview yesterday where the client asked if I could reproduce the heirarchical drill down features they currently have in MS SQL Reporting Services. The design they showed me was where there was a plus sign by each row and when you clicked it, it opened a subsection with additinoal detail. If you then clicked on the minus , it closed the subsection.

I told the interviewers that I could use a dynamic subreport with a link from the main report page, but they did not seem impressed, wanting all the detail on the same page and my sample report created a second preview page for the subreport. Any ideas or suggestions would be appreciated.

Fuskie

Who adds that he was just offered the contract, so any suggestions you might have would make his new masters very happy...

[former_member260594]

Fuskie,

I can't see this really happening in CR. You could create a + symbol in the GH for a visual effect but if the user clicks anywhere in the GH it will drill down with a new page. Closing that page by clicking on anything other than the x will prove very difficult.

You could however export (or schedule) a repot to PDF and select the create Create bookmarks from grouptree option. Then in adobe they can browse via the group tree + or - icons

or

Export to Excel Data only and enable the Show Group Outlines option

[ido_millet]

afaik, this can't be done just with Crystal but there are 3rd-party Crystal tools (see list at http://www.kenhamady.com/bookmarks.html) that add this functionality.

For a 1-minute demo of how this works in my DataLink Viewer software, see: http://www.milletsoftware.com/Download/DLV_InPlace_DrillDown.wmv