Re Out of Memory exception while running SSRS report
<p>I am creating a report with requirement to select all parameter values(have 3 parameters)</p>

<p>But, when I am running this report it throws System Out of Memory exception.</p>

<p>I tried selecting few values but even that doesnt work.</p>

<p>Any suggestions how can I avoid this?</p>

<pre><code>Dataset 1: 
SELECT col1, col2, col3, col4, col4, col5, col6, col7, col8
from storedproc
WHERE col1 IN ('A')
AND col2 IN (1) 

Dataset 2:

SELECT DISTINCT col3
FROM  storedproc
WHERE        (col2 = @col2)

Dataset 3:
SELECT DISTINCT 
col1, col3,
col4 COLLATE DATABASE_DEFAULT + ' - ' + col5 COLLATE DATABASE_DEFAULT + ' - ' + col6 COLLATE DATABASE_DEFAULT
 + '   ' + CONVERT(char(5), col7, 108) + ' - ' + CONVERT(char(5), col8, 108) AS Alias_col
FROM        storedproc
WHERE        (col2 = @col2)
</code></pre>