What is the Maximum number of Grouping allowed in SSRS 2005?

Question

Hi,

I have a report developed in SSRS 2005, which has 9 levels of grouping for drill down (toggle). The toggle works fine when the report is generated from the VS 2005.

- Level 1
           - Level 2
                     - Level 3
                                 - Level 4
                                               ........
                                                       - Level 9
                                                                  Detail Row


But when i export the report to Excel the groupings doesn't work properly. And i found in the top left corner of the excel it showed 8 levels instead of 9 levels.

Is there any limitation for groupings?

---

C.Manojkumar

Answer 1

Hi,

In SSRS 2005, although the report is collapsed by toggle, the report will be expanded while exported to excel.  This is to be corrected untill SSRS 2008.

The report with 9 levels is exported to excel in my environment(SSRS 2005 sp3), and still has 9 levels rather than only 8 levels. Untill now, i did not see any document to describe the limitations about nested group of reporting service, but at least it exceeds 9. Please try again and provide so more details that we can repro if any tricky problems you encounter in building report progress.

thanks,
Jerry