How to refresh a crystal report !!

Question

User-746270871 posted

I deployed my website in IIS 7.5, when i click on the button to open the page that contain the report, i get a blank page for the first time,but when i refresh the page it's ok. it's happened just for the first load. how can i fix this problem ?
 
please help me.Thanks in advance.

Answer 1

User705563967 posted

check the code written inside the postback

better to share your code.

Answer 2

User-746270871 posted

protected void BtnOuvrirRapport(object sender, EventArgs e)
     {
          ReportDocument rptdoc = new ReportDocument();
          examenTableAdapter adapter = new examenTableAdapter();
          DataTable dt = adapter.GetData();
          rptdoc.Load(Server.MapPath("NB_EXAMNE_Report.rpt"));
          rptdoc.SetDataSource(dt);
          rptdoc.RecordSelectionFormula = "{examen.study_rv_date}   in {?fromdate} to  {?todate}";
          Session["rd"] = rptdoc;
          rptdoc.Refresh();
      }


 protected void Page_Load(object sender, EventArgs e)
  {
    Response.AppendHeader("Refresh", "900");
    ReportDocument rd = (ReportDocument)Session["rd"];
    CrystalReportViewer1.ReportSource = rd;
    CrystalReportViewer1.DataBind();
    CrystalReportViewer1.RefreshReport();
    CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;
    GC.Collect();
  }

Answer 3

User705563967 posted

You did not pass rptdoc to Crystal report viewer on button click

used this command on button click because first page load is called then button click you calling report viewer on page load and set report parameter on function check below code

CrystalReportViewer1.ReportSource = rd;
    CrystalReportViewer1.DataBind();
    CrystalReportViewer1.RefreshReport();

protected void BtnOuvrirRapport(object sender, EventArgs e)
     {
          ReportDocument rptdoc = new ReportDocument();
          examenTableAdapter adapter = new examenTableAdapter();
          DataTable dt = adapter.GetData();
          rptdoc.Load(Server.MapPath("NB_EXAMNE_Report.rpt"));
          rptdoc.SetDataSource(dt);
          rptdoc.RecordSelectionFormula = "{examen.study_rv_date}   in {?fromdate} to  {?todate}";
          Session["rd"] = rptdoc;
    CrystalReportViewer1.ReportSource = rd;
    CrystalReportViewer1.DataBind();
    CrystalReportViewer1.RefreshReport();
      }

Answer 4

User-746270871 posted

thanks for your reply,

but the code of button and page that contain crystalviewer it's not in the same page.aspx that's why i used session.

this code is not accepted in the page that contain the button...

CrystalReportViewer1.ReportSource = rd;
    CrystalReportViewer1.DataBind();
    CrystalReportViewer1.RefreshReport();
      }

Answer 5

User705563967 posted

call the same button code on page load without using selection formula and check it is working fine