Reporting Services error on execution

[MikiJB]

SSRS 2005 - quite new to SQL.

I'm getting the following error in Reporting Services only:
-------------
An error has occurred during report processing.
Cannot read the next data row for the data set HSBCClaimsBordereau.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
-------------
I don't get the error on preview in Visual Studio, and the Stored Procedure it calls runs smoothly as well.

My parameters are definitely set correctly, and I've checked for "Warning: Null value is eliminated by an aggregate or other set operation", and that's not happening.

Does anyone have any ideas what else might be causing this?

Thanks

MIKI

 

[fuzzyocelot]

Have you checked the error logs on the server? It might help give you an idea of what the problem really is.

 

[tstocksql]

We had an error like this when one of our sub selects had a cartesean join and was only suppose to return 1 record. Did you run the report from a broswer directly where the reporting server service is running?

Also, try grabbing the query the report is running for it's data set and run it directly in SQL Management studio. It helped us in rooting out the problem. Good luck!