Clever Geek Handbook

What can cause an SSRS report to fail on the report server when rendering?

The details are as follows:

Environment:

SSRS Server 2008, SQL Server 2008 for Database, Report Developed in SQL Server Business Intelligence Devlopment Studio - Reporting Project

Error messages:

"An error occurred while rendering the client." "An error occurred while processing the report." "Query execution failed for dataset" DataSource1 "." "For more information on this error, go to the report server on your local server or remove the errors."

I did this (navigation and all) and the result was that a scalar variable parameter should be declared. The funny thing is that these variables are properly declared in the data source and in the report sources everywhere. Also this report / data source did not work in SSRS 2005. In a development environment, the report works fine. On the server, the report is completed only on execution and after the parameters are accepted. We don't use stored procedures.

Any ideas / ideas are greatly appreciated.

Thanks in advance.

+1


source to share


2 answers


I was having problems in SSRS 2005 where deploying changes to a report was incorrectly updating parameter changes, specifically new parameters. Fixed deleting an existing report using Report Manager and then loading the modified version.

Hope it helps,



Bill

+1


source


When running in Dev environment, you are using Windows credentials. Are you also using your Windows credentials when going through SSRS? or are you using different credentials?



+1


source






More articles:


All Articles