I have a report showing location, department and employee name & salary. All of the fields are from same table. I group on location first and then on department. All the groups have group headers. Detail row has employee name & salary.
My report is showing perfect but I want to implement drill down technique. I want to show plus minus symbol for the group. When opened the report should show only location names with plus signs. Then when a user clicks on a plus sign then all departments will show under that location. And when the user clicks on department plus sign then all employee details should show under that department.
I searched google and follow links are
http://www.sqlservercurry.com/2009/08/creating-drill-down-report-with-sql.html
I followed their instructions to build expand collapse functionality into my report but failed. Please guide me how to show report location & department wise with expand collapse functionality.