Report render error when called from ReportViewer Control

By Akbar • December 31st, 2007

A few days ago I was looking at a weird report render issue, where one of the sub-report was being correctly rendered when called from the MS Report Server web management interface, but was giving the generic error “Subreport can not be shown” when called from the ASP.net page using ReportViewer control. On debugging the issue, I found that Reporting Server, when called via web-service, was try to execute the SQL Server’s stored procedure using an account (due to Window’s Authentication mode) which didn’t had the EXECUTE permission for the that particular stored procedure. A quick fix is to just grant the EXECUTE permission to the stored procedures which are called by Reporting Server.

I also learned another tip during this debugging session, when you get the annoying “Subreport can not be shown” error, you can get the actual exception which is causing the problem by looking at the Debug/Output window in the Visual Studio when running the application in DEBUG mode.

Tags: , , ,

This entry was posted on Monday, December 31st, 2007 at 4:20 pm and is filed under ASP.Net. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.