title: Out of memory exception Error when generating a SSRS report
body: <p>I'm creating an SSRS report using report builder that generated large amount of data based on from to dates parameters.</p>
  
  <p>If I run the report up to 3 months the report works fine, however when generating the report for a longer period generating larger amount of data an system out of memory exception error is thrown.</p>
  
  <p>Note that if I run the query for the same period but from inside the data set it will be generated in seconds.</p>
  
  <p>Also when generating the report from 
  <a href="http://servername/Reports/Pages/Folder.aspx" rel="nofollow noreferrer">http://servername/Reports/Pages/Folder.aspx</a> it will keep loading without generating any data, I've tried to modify the rsreportserver.config file with the following with no success        </p>
  
  <pre><code>&lt;MemorySafetyMargin&gt;80&lt;/MemorySafetyMargin&gt;
          &lt;MemoryThreshold&gt;90&lt;/MemoryThreshold&gt;
          &lt;WorkingSetMaximum&gt;4000000&lt;/WorkingSetMaximum&gt;
          &lt;WorkingSetMinimum&gt;2400000&lt;/WorkingSetMinimum&gt;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/BJ5F9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BJ5F9.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/BPQgn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BPQgn.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/DbEtP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DbEtP.jpg" alt="enter image description here"></a></p>