Issue with large data in SSRS

Question

Hi,

   In a current SSRS project I am working on - we get the data from sql server as per some id value and populate the data in a shared dataset and then set a parameter and from the parameter we set the datset corresponding to some rdl.In 1 of the rdls,the data comimg from the sql server is more than 20 mb and we get a memory out of exception.Do we need to increase the size of the default datset and the parameter?Please provide some solution.It's really very urgent.

Thanks and Regards,

Sandip

Answer 1

Hi Sandip,

Your approach appears to me incompletely expressed but nverthless

What parameter in particular are you talking about?

I am also thinking, if you cannot control the amount of the data being received, how would you be able to make your mind regrading how to quantify the increase?

---

Arthur My Blog

Answer 2

Hello,

The error “OutOfMemoryException” occurs when the computer does not have sufficient memory to complete the requested operation. To solve this issue, we should redesign the report to consume less memory. Please refer to the following methods to redesign the report.
1. Redesign the report queries. For example, return less data in the report queries and use a better restriction on the WHERE clause of the report queries.
2. Simplify the report design. We can use less data regions or controls in the report, or use drillthrough report to display details
For more methods, please refer to the following articles：
Troubleshooting Reports: Report Performance
You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support