I'm using windows authentication and impersonation - the sql account has access to the report db. can't figure out why it won't render the report - just shows a blank page
I've installed report viewer 9 and 10, restarted the reporting services and rebooted the pc but get the same result - blank page where the report should render. The report doesn't have any parameters and I've got windows auth, impersonation and the account
set to browse on the folder. this is very frustrating.
can you please give your user to render browse and some more acceess for that report, i think its the permission related issue.
the user you've impersonated, is that exists on both your app server and Reports server?
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
I have domain\serviceacct as the account for impersonation. On the reports server I enabled that account to have: Browser - May view folders, reports and subscribe to reports.
sql server - the domain account is in the local admins group and iis_iusrs group. in sql the domain account is dbo on reportserver and reportservertempdb databases.
web server - the domain account is in the local admins group and iis_iusrs group.
wmaaz
Member
10 Points
6 Posts
report viewer not rendering
Mar 14, 2012 07:44 PM|LINK
hello im using vs2010 and placed the reportviewer control on a page and can't get it to render
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" InteractiveDeviceInfos="(Collection)" ProcessingMode="Remote" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Visible="true" Height="600px"> <ServerReport ReportServerUrl="http://sql-server/ReportServer" ReportPath="/test/t Reports/report data" /> </rsweb:ReportViewer>
I'm using windows authentication and impersonation - the sql account has access to the report db. can't figure out why it won't render the report - just shows a blank page
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: report viewer not rendering
Mar 15, 2012 05:38 AM|LINK
Did you install report viewer on your system ? If not please install the report viewer from
http://www.microsoft.com/download/en/details.aspx?id=577 (Report Viewer 9.0)
http://www.microsoft.com/download/en/details.aspx?id=6442 (Report Viewer 10.0)
Based on the version of the report viewer you are using your application (rs:Web version), please install the relative verison of it.
After installation, restart the REPORTING SERVICES service from services.msc or Restart your pc.
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
wmaaz
Member
10 Points
6 Posts
Re: report viewer not rendering
Mar 15, 2012 12:11 PM|LINK
I've installed report viewer 9 and 10, restarted the reporting services and rebooted the pc but get the same result - blank page where the report should render. The report doesn't have any parameters and I've got windows auth, impersonation and the account set to browse on the folder. this is very frustrating.
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: report viewer not rendering
Mar 16, 2012 04:13 AM|LINK
can you please give your user to render browse and some more acceess for that report, i think its the permission related issue.
the user you've impersonated, is that exists on both your app server and Reports server?
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: report viewer not rendering
Mar 16, 2012 05:09 AM|LINK
Please post your code of aspx page, cs page and web.config (tags for report viewer).
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
wmaaz
Member
10 Points
6 Posts
Re: report viewer not rendering
Mar 16, 2012 12:11 PM|LINK
I have domain\serviceacct as the account for impersonation. On the reports server I enabled that account to have: Browser - May view folders, reports and subscribe to reports.
sql server - the domain account is in the local admins group and iis_iusrs group. in sql the domain account is dbo on reportserver and reportservertempdb databases.
web server - the domain account is in the local admins group and iis_iusrs group.
not sure why it doesn't work
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: report viewer not rendering
Mar 16, 2012 12:15 PM|LINK
Does the report viewer say -- > Loading while you load the reports ? and then nothing comes up
OR
Repor viewer itself is not coming up on the screen ?
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
wmaaz
Member
10 Points
6 Posts
Re: report viewer not rendering
Mar 16, 2012 12:16 PM|LINK
nothing happens, blank page - that's what is odd
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: report viewer not rendering
Mar 16, 2012 12:18 PM|LINK
Okay, this is weird, consider the fact that you have installed the Report viewer.
Please help by posting your aspx page code here. If possible (web.config)
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
wmaaz
Member
10 Points
6 Posts
Re: report viewer not rendering
Mar 16, 2012 12:19 PM|LINK
yes - installed the suggested software on my local pc, the web server and sql server. will have the code posted soon