I have a report that uses a stored procedure.
I added a parameter called batchno which is an integer.
The SQL works fine in the database. When I use the report with the same data value I get the System.Outof memory Exception message.
I re-created the report several times. In the parameters section I ensured the parameters appear. In the data section the parameters appear.
The batch parameter is a nullable value and set to null in the DB and in the report before running.
and (PRB.BatchNo = (@BatchNo) or @BatchNo is Null)
Not sure what the problem is.