report viewer not rendering

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

Re: report viewer not rendering

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.

Re: report viewer not rendering

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.

Re: report viewer not rendering

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?

Re: report viewer not rendering

Please post your code of aspx page, cs page and web.config (tags for report viewer).

Re: report viewer not rendering

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

Re: report viewer not rendering

Does the report viewer say -- > Loading while you load the reports ? and then nothing comes up

Repor viewer itself is not coming up on the screen ?

Re: report viewer not rendering

nothing happens, blank page - that's what is odd

Re: report viewer not rendering

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)

Re: report viewer not rendering

yes - installed the suggested software on my local pc, the web server and sql server. will have the code posted soon

Re: report viewer not rendering

should be enough

have a user control (view report) on a host page

user control: <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="uctest.ascx.cs" Inherits="project.uctest" %> <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %> <%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<div class="contentmain"> <asp:Panel ID="pnltest" runat="server" Visible="true"> <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> <asp:LinkButton ID="lnkbtnView" runat="server" onclick="lnkbtnView_Click" >View Report</asp:LinkButton>  <asp:Panel ID="pnlView" runat="server" Visible="false"> report <br /> <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> </asp:Panel> </asp:Panel> </div>

host page: <%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="project.test" %> <%@ Register src="usercontrols/uctest.ascx" tagname="uctest" tagprefix="uc1" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent"> </asp:Content> <asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"> <uc1:uctest ID="uctest1" runat="server" /> </asp:Content>

site.master: <%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Site.master.cs" Inherits="project.SiteMaster" %> <%@ Register src="usercontrols/greeting.ascx" tagname="greeting" tagprefix="uc1" %> <%@ Register src="usercontrols/navigation.ascx" tagname="navigation" tagprefix="uc2" %> <%@ Register src="usercontrols/footer.ascx" tagname="footer" tagprefix="uc3" %> <%@ Register src="usercontrols/header.ascx" tagname="header" tagprefix="uc4" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head runat="server"> <title></title> <link href="~/Styles/Site.css" rel="stylesheet" type="text/css" /> <style type="text/css"> .hideMainForm { position: absolute; top:-10000px; left:-10000px; } .showMainForm { position:absolute; width: 100%; } </style> <script type="text/javascript" src="Scripts/jquery-1.4.1.js"></script> <script type="text/javascript"> $(document).ready(function () { $("#Form1").removeClass('hideMainForm'); if ($.browser.msie) { if ($.browser.version <= 7) { $("#Form1").addClass('showMainForm'); } } }); </script> <asp:ContentPlaceHolder ID="HeadContent" runat="server"> </asp:ContentPlaceHolder> </head> <body> <form id="Form1" runat="server" class="hideMainForm" > <div class="page"> <div class="header" style="z-index:10;"> <div class="title"> <uc4:header ID="header1" runat="server" /> </div> <div class="loginDisplay"> <uc1:greeting ID="greeting1" runat="server" /> </div> <div class="clear hideSkiplink"> <uc2:navigation ID="navigation1" runat="server" /> </div> </div> <div class="main" style="z-index:-1;"> <asp:Label id="lblBrowser" runat="server" Visible="false"></asp:Label> <asp:ContentPlaceHolder ID="MainContent" runat="server" /> </div> <div class="clear"> </div> </div> <div class="footer"> <uc3:footer ID="footer1" runat="server" /> </div> </form> </body> </html>

css: /* DEFAULTS ----------------------------------------------------------*/ body { background: #b6b7bc; font-size: .80em; font-family: Arial, sans-serif; margin: 0px; padding: 0px; color: #696969; }

a:link, a:visited { color: #034af3; }

a:hover { color: #1d60ff; text-decoration: none; }

a:active { color: #034af3; }

p { margin-bottom: 10px; line-height: 1.6em; }

/* HEADINGS ----------------------------------------------------------*/ h1, h2, h3, h4, h5, h6 { font-size: 1.5em; color: #666666; font-variant: small-caps; text-transform: none; font-weight: 200; margin-bottom: 0px; }

h1 { font-size: 1.6em; padding-bottom: 0px; margin-bottom: 0px; }

h2 { font-size: 1.5em; font-weight: 600; }

h3 { font-size: 1.2em; }

h4 { font-size: 1.1em; }

h5, h6 { font-size: 1em; }

/* this rule styles <h1> and <h2> tags that are the first child of the left and right table columns */ .rightColumn > h1, .rightColumn > h2, .leftColumn > h1, .leftColumn > h2 { margin-top: 0px; }

/* PRIMARY LAYOUT ELEMENTS ----------------------------------------------------------*/ .page { width: 95%; background-color: #fff; margin: 5px auto 0px auto; border: 1px solid #496077; }

.header { position: relative; margin: 0px; padding: 0px; background: #4b6c9e; width: 100%; }

.header h1 { font-weight: 700; margin: 0px; padding: 0px 0px 0px 20px; color: #f9f9f9; border: none; line-height: 2em; font-size: 2em; }

.contentmain { background-color:White; padding: 10px 10px 10px 10px; border: 1px solid #496077; }

.main { padding: 0px 12px; margin: 12px 8px 8px 8px; min-height: 420px; }

.leftCol { padding: 6px 0px; margin: 12px 8px 8px 8px; width: 200px; min-height: 200px; }

.footer { color: #4e5766; padding: 8px 0px 0px 0px; margin: 0px auto; text-align: center; line-height: normal; }

/* TAB MENU ----------------------------------------------------------*/ div.hideSkiplink { background-color:#3a4f63; width:100%; }

div.menu { padding: 4px 0px 4px 8px; }

div.menu ul { list-style: none; margin: 0px; padding: 0px; width: auto; }

div.menu ul li a, div.menu ul li a:visited { background-color: #465c71; border: 1px #4e667d solid; color: #dde4ec; display: block; line-height: 1.35em; padding: 4px 20px; text-decoration: none; white-space: nowrap; }

div.menu ul li a:hover { background-color: #bfcbd6; color: #465c71; text-decoration: none; }

div.menu ul li a:active { background-color: #465c71; color: #cfdbe6; text-decoration: none; }

/* FORM ELEMENTS ----------------------------------------------------------*/ fieldset { margin: 1em 0px; padding: 1em; border: 1px solid #ccc; }

fieldset p { margin: 2px 12px 10px 10px; }

fieldset.login label, fieldset.register label, fieldset.changePassword label { display: block; }

fieldset label.inline { display: inline; }

legend { font-size: 1.1em; font-weight: 600; padding: 2px 4px 8px 4px; }

input.textEntry { width: 320px; border: 1px solid #ccc; }

input.passwordEntry { width: 320px; border: 1px solid #ccc; }

div.accountInfo { width: 42%; }

/* MISC ----------------------------------------------------------*/ .clear { clear: both; }

.title { display: block; float: left; text-align: left; width: auto; }

.title a:link { color: white; }

.title a:visited { color: white; }

.title a:hover { color: white; }

.loginDisplay { font-size: 1.1em; display: block; text-align: right; padding: 10px; color: White; }

.loginDisplay a:link { color: white; }

.loginDisplay a:visited { color: white; }

.loginDisplay a:hover { color: white; }

.failureNotification { font-size: 1.2em; color: Red; }

.bold { font-weight: bold; }

.submitButton { text-align: right; padding-right: 10px; }

.listsearcher { background-color: #cccccc; color: #496077; }

web.config: <?xml version="1.0"?>

</configuration>