Heirarchical Drill Down Reports
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.
Who adds that he was just offered the contract, so any suggestions you might have would make his new masters very happy...