Problem in creating reports

Question

User-1919429754 posted

Hello,

I created a report with the name "rptClient.rdlc". i created a dataset and designed the report fields. And this is my asp.net code to display the report,

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
        Font-Size="8pt" InteractiveDeviceInfos="(Collection)" WaitMessageFont-Names="Verdana"
        WaitMessageFont-Size="14pt">
        <LocalReport ReportPath="Admin\rptClient.rdlc">
            <DataSources>
                <rsweb:ReportDataSource Name="DataSet1" />
            </DataSources>
        </LocalReport>
    </rsweb:ReportViewer>
    &nbsp;<asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>

And this is my c# code to set the datasource,

        public ReportDataSource rptSource;

        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ToString());
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter("select ClientID,FirstName,Surname from Client", con);
            DataSet ds = new DataSet("Client");
            da.Fill(ds, "Client");

            con.Close();
            con.Dispose();

            this.ReportViewer1.Reset();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("rptClient.rdlc");
            rptSource = new ReportDataSource();
            rptSource.Name = "DataSet1";
            rptSource.Value = ds.Tables[0];
            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.DataSources.Add(rptSource);
            this.ReportViewer1.DataBind();
            this.ReportViewer1.LocalReport.Refresh();


        }

when i run the program the report is keep on loading. i could not get the result.

Can anyone help me to solve this issue. if this is not the proper way of generating a report pleast let me know the method as well.

thank you

Answer 1

User-417640953 posted

this.ReportViewer1.LocalReport.Refresh();

Hi prathap,

Thanks for posting this issue to asp.net forum.

According to your code, I see that you using the Refresh() method in page load event.

Refresh() will generate a postback, and it will keep posting and posting.  Please add your code like below.

  if (!IsPostBack) 
  { 
     //your code....
   
  }

If has any doubt, feel free to back. Thanks.

Best Regards!

Answer 2

User-1919429754 posted

Hi,

Thank you very much. I changed the code according to your instructions, and it works fine now.

thanks a lot.

prathap