locked
report viewer not rendering RRS feed

  • Question

  • User-355450878 posted

    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

     

    Wednesday, March 14, 2012 3:44 PM

All replies

  • User-8475372 posted

    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. 

    Thursday, March 15, 2012 1:38 AM
  • User-355450878 posted

    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.

    Thursday, March 15, 2012 8:11 AM
  • User2105670541 posted

    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?

    Friday, March 16, 2012 12:13 AM
  • User-8475372 posted

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

    Friday, March 16, 2012 1:09 AM
  • User-355450878 posted

    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

    Friday, March 16, 2012 8:11 AM
  • User-8475372 posted

    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 ? 

    Friday, March 16, 2012 8:15 AM
  • User-355450878 posted

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

    Friday, March 16, 2012 8:16 AM
  • User-8475372 posted

    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)

    Friday, March 16, 2012 8:18 AM
  • User-355450878 posted

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

    Friday, March 16, 2012 8:19 AM
  • User-355450878 posted

    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> <!-- onclick shows the panel --> <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         {             ;             top:-10000px;             left:-10000px;         }         .showMainForm         {            ;            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" /><!--where the content loads -->         </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 {     ;     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>   <appSettings>     <add key="ldapConnection" value="LDAP://dc" />     <add key="adDomain" value="test" />       <add key="adUser" value="svcact" />     <add key="adPassword" value="pas" />       <add key="applicationTimeout" value="1800" />   </appSettings>     <connectionStrings>     <add name="ConnectionString" providerName="System.Data.SqlClient" connectionString="server=tcp:svr,1433;uid=a;pwd=A;database=A" />     <add name="MsAConnectionString" providerName="System.Data.SqlClient" connectionString="server=tcp:svr,1433;uid=ms;pwd=ms;database=M" />    </connectionStrings>     <system.web>     <httpHandlers>       <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"         validate="false" />     </httpHandlers>     <identity impersonate="true" />     <authentication mode="Windows" />     <authorization>       <deny users="?" />     </authorization>     <roleManager enabled="true" defaultProvider="AspNetWindowsTokenRoleProvider" />     <trust level="Full" originUrl="" />     <compilation debug="true" strict="false" explicit="true" defaultLanguage="c#"       targetFramework="4.0">       <assemblies>         <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />         <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />         <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />         <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />       </assemblies>       <buildProviders>         <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />       </buildProviders>     </compilation>     <customErrors redirectMode="ResponseRewrite" defaultRedirect="~/error.aspx" mode="Off">       <error statusCode="500" redirect="~/servererror.aspx" />       <error statusCode="404" redirect="~/filenotfound.aspx" />       <error statusCode="403" redirect="~/accessdenied.aspx" />     </customErrors>     <trace enabled="true" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />     <sessionState timeout="35" />     <httpRuntime maxRequestLength="8192" enable="true" executionTimeout="220" requestLengthDiskThreshold="512" maxQueryStringLength="2048" maxUrlLength="260" />   </system.web>     <location path="scripts">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <location path="images">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <location path="styles">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <location path="WebResource.axd">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <location path="ReportViewerWebControl.axd">   <system.web>     <authorization>       <allow users="*" />     </authorization>   </system.web> </location>     <system.webServer>     <modules runAllManagedModulesForAllRequests="true" />     <validation validateIntegratedModeConfiguration="false" />     <httpErrors errorMode="Custom">       <remove statusCode="500" subStatusCode="-1" />       <error statusCode="500" path="/servererror.aspx" responseMode="ExecuteURL" />       <remove statusCode="404" subStatusCode="-1" />       <error statusCode="404" path="/filenotfound.aspx" responseMode="ExecuteURL" />       <remove statusCode="403" subStatusCode="-1" />       <error statusCode="403" path="/accessdenied.aspx" responseMode="ExecuteURL" />     </httpErrors>     <handlers>       <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd"            type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />       <add name="Reserved-ReportViewerWebControl-axd" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler"            resourceType="Unspecified" preCondition="integratedMode"/>     </handlers>   </system.webServer>     <system.net>     <mailSettings>       <smtp>         <network host="svrh" port="25" userName="svc" password="pas" />       </smtp>     </mailSettings>   </system.net>

    </configuration>

     

    Friday, March 16, 2012 8:28 AM