I am running a report in SSRS 2008 and error occured saying '(Exception Of Type (System. OutofMemoryException) was thrown)'.
It is stored procedure connected to the report. And this stored proceedure consists of small functions and subqueries which is making the report to run slow.
As all the functions and sub queris are needed, they can't be tweaked.
the total no. of records when (stored procedure) executed in sql server are 1673 records.
Just an FYI - This report runs fine from 'crystal report application' but times out when run from 'crystal report viewer'.
Please give any suggestion to run it successfully through SSRS 2008.