Error when trying to display a report

Hi,

I'm trying to create a new custom report in studio 2005 (Report server project).

When the wizard in finished, I'm trying to run the report and get the following

error:

An error .. during local report processing 'system.outofmemoryException'..

Thanks,

Michael

[316 byte] By [MichaelSabbag] at [2008-2-10]
# 1

If you are running out of memory, it is probably because the MDX query used is returning too much data, look into optimizing the query or modifying the report so that data is filtered at the dataset level. Check out the following post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=22652&SiteID=1

Thanks,
Othmane

OthmaneRahmouni-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 2

Hi there,

Were you able to resolve these issues? Please let me know if we can help further.

Thanks!

Mauli

MauliShah-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 3
See this page ( http://www.zen-turkey.com/blog/default.aspx?id=38&t=SQL-2005-Analysis-Services-MDX-Query-thr ) for further information.

Cheers :-)

Peter999999 at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...

Visual Studio Team System

Site Classified