Okay this is first time i am coming across something like this . I am dveloping Reports using SSRS 2008 and my Database is Oracle11g. My work works fine with parameters but when i remove params and change my dataset query to select * from myreport and preview it i get an error message: cannot read the next data row for the datasetDataSet1 ORA-12801:Error signaled in parallel query server PO15ORA-04030: Out of Process Memory when trying to allocate 254488 bytes(QERHJ Hash-joi,kllcqas:kllsltba However when i right click on Dataset Properties and execute the same query from Query designer its runs fine and i see data.. Why is this happeninng? Has any noticed similar issue? FMFM

Farhan1, How many records are you pulling into the report? BIDS is a 32 bit application and won't be able to handle huge datasets. Try deploying the report to Report Manager and see what happens.

Shah, I did that and i get an error as well from the Report manager An error occurred during client rendering. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. For more information about this error navigate to the report server on the local server machine, or enable remote errors FM

Shah my query is a view which has about 30 clos in the select stmt but my report only uses 15 cols from the view .FM

Hi Farhan, My suggestion would be limit the number of records by assigning some default values for the parameters. For example, limit the number of records with 2yrs of data or one year of data. I think pulling all the data is not a good idea. Users can go back if they wanted to see the old data. Follow these steps: Check the parameter rendering, data retrieval, & query execution time for your report. Check the duration of each task and try to work on performance. Use the following query to get these --use Report Server DB. Select * Executionlog2

Thank you all for valid suggestions however we created a stored proc and everything works normal nowFM