Visibility Hidden On A Group Causes An Out Of Memory Error

Hi,
Running visual studio 2005 on win XP with 2GB ram.

Reporting server Windows 2003, SQL 2005 Enterprise

I have a SSRS 2005 report that runs just fine when all fields are expanded. All the groups are there, and all is right with the world.

I now right click the detail line, edit group, choose visibility, select "visibility can be toggled by another report item", leaving "initial visibility" as "Visible" and again, the report runs in about 10 seconds and works fine.

I go back into the report and choose visibility and set the initial visibility to "hidden" and the report runs for a little longer (not much) but fails with a "system.outofmemoryexception" error. this happens when the "devenv.exe" process hits about 840MB.

Has anyone found a work around to this issue? The report is returning about 28,000 records of about 23 fields, so it isn't as if it is a massive data set that it is working with.

There are a lot of small groups, but even if I turn off the togge option, with the group having an initial visibility of hidden, the memory usage goes through the roof until the PC runs out of memory.

Curiously, when I publish the report to the same PC and run it in IE, it runs with no problems (albeit take a long time to retunr rows - even though the query runs in under a second).

It appears to be the rendering that is causing the memory balloon. Is there any way to reduce the memory usage of the rendering engine?


Any ideas would be appreciated