An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dataset1'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors I am getting the above exception only when my input criteria is more.since i m passing 'ids' as comma separated value as input to my sp.with less number of input it is working fine. Please help me.

Hello, It seems the issue is in your query. You can execute your SP with the same parameters in Query Analyzer to see the error. Or you can also execute the report on local server machine, i.e. where reporting services are installed to see the actual error. Hope this will help you detemine the actual error. Thanks Salman http://muhammadsalmanx.wordpress.com

Results are being fetched when I execute my SP with same parameters in Query Analyzer.And also executes in local server machine.When called from my application with same parameters I am getting the exception.

When called from my application with same parameters I am getting the exception. Are you calling the report from external application? Do you have multiselect parameter dropdown in your SSRS report for same parameter? If yes you can check if all comma separated values that you are sending to parameter exist in the resultset returned by SSRS multivalued parameter dataset. If not then your application will throw error. Thanks Salman http://muhammadsalmanx.wordpress.com

Yes parameter exist in the resultset returned by SSRS dataset.Same works with less parameters say about 20 values in comma separated value.If more than that its throwing exception.

Hi, Could you please post the query statement and the values for the parameter? This help us to troubleshoot the issue. Thanks, Jin ChenJin Chen - MSFT