Report viewer doesnt display on page RRS feed

  • Question

  • User215562100 posted

    Hi all, I am having a problem with a report.

    when i load the page, the page keeps loading endlessly.

    my server uses iis v6.0 but when i run the same on my local machine with iis v7.0 the reprt displays.

    other reports on the same server with iis v6.0 display except thisone.

    please find below the codes


    <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
        validate="false" />


    <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
        Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
    <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
                    <asp:Label ID="lblMessage" runat="server" CssClass="lblStatus"></asp:Label>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
            Font-Size="8pt" Height="400px" Width="892px" Visible="False">
            <LocalReport ReportPath="Report.rdlc">
                    <rsweb:ReportDataSource DataSourceId="ObjectDataSource2" 
                        Name="CertDs_IPA_cert_insert" />
        <asp:ObjectDataSource ID="ObjectDataSource2" runat="server" 


     Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            If Not IsPostBack Then
                ReportViewer1.Visible = True
                Dim thisDataSet As New DataSet
                Dim params() As SqlParameter = {New SqlParameter("@ClientID", Request.QueryString("ClientID"))}
                Dim myReader As SqlDataReader = Nothing
                myReader = SqlHelper.ExecuteReader(Connstring, CommandType.StoredProcedure, "IPA_cert_insert", params)
                If myReader.HasRows Then
                    srsPath = myReader.GetString(20)
                End If
                thisDataSet = SqlHelper.ExecuteDataset(Connstring, CommandType.StoredProcedure, "report_display", params)
                Dim ds As ReportDataSource = New ReportDataSource("rptDs_report_display", thisDataSet.Tables(0))
                ReportViewer1.LocalReport.EnableExternalImages = True
                Dim rptParam2 As New ReportParameter("Path", "http://" + Request.Url.Host + "/" + ResolveUrl(srsPath))
                ReportViewer1.LocalReport.SetParameters(New ReportParameter() {rptParam2})
                If thisDataSet.Tables(0).Rows.Count = 0 Then
                    lblMessage.Text = "Sorry, no report"
                    ReportViewer1.Visible = False
                    lblMessage.Text = ""
                End If
            End If
        End Sub

    Thank u

    Tuesday, September 25, 2012 2:44 AM

All replies

  • User803630265 posted

    what is using asp.net option u select asp.2

    Tuesday, September 25, 2012 9:45 AM
  • User215562100 posted

    what is using asp.net option u select asp.2

    hi surjeet_kumar1

    I dont understand by "what is using asp.net option u select asp.2"

    do you mean option in IIS?


    Wednesday, September 26, 2012 4:56 AM
  • User803630265 posted

    yes iis option  change

    Thursday, September 27, 2012 5:29 AM