I've developed a workaround for the recursive Parent-Child issue where groups do not export out to Excel properly (no expand\collapse navigation, no stepped groups) that involves setting up a group for each parent and then applying a filter for
the parent on the UniqueName. Children groups can then be set up with the Group set to ParentUniqueName. This works great, except that I now have 30+ groups. The designer (both the BIDS and ReportBuilder) have slowed down to a crawl where
each click or keyboard navigation etc. takes 7+ seconds. This has made report building extremely painful! It is not a hardware problem, as I have tried it on a number of high powered machines with the same results. The report
itself runs relatively quickly.
Is there an upper limit for the number of groups that SSRS designer is meant to work with, or a workaround that I am not aware of?
View Complete Post