set datasource from report(Start report event)

Comments

• woodlumb

  November 2016 edited November 2016

  All code in previous post is set in _StartReport event in report.
  I get error when i set

    Data1.DataSource = tab;
  

  
  Objects 'tab' and 'dt' are global object.
  
  Where the problem is ?
• ipong

  November 2016 edited 5:57AM

  read FRNetProgrammerManual-en.pdf for registering data
• woodlumb

  November 2016 edited November 2016

  I read instruction , but RegisterData(...) don't work in _StartReport event. Before Load(...) is work correctly.
• ipong

  November 2016 edited 5:57AM

  follow the pattern as instructed by fastreport, never use event for registering data.
  
  in my case, when i click a button, execute this method :
  
  assuming desktop application and already declared fastreport previewcontrol (internal FastReport.Preview.PreviewControl PreviewControl1;)
  

          private void GLReportBS()
          {
              try
              {
                  using (OleDbConnection cnn = new OleDbConnection(ClassGlobal.mySQLConnString))
                  {
                      cnn.Open();
  
                      using (OleDbCommand cmd = new OleDbCommand())
                      {
                          cmd.Connection = cnn;
                          cmd.CommandType = CommandType.Text;
                          cmd.CommandText = "SELECT * FROM qryRptBS";
  
                          using (OleDbDataReader dr = cmd.ExecuteReader())
                          {
                              if (dr.HasRows == false)
                              {
                                  throw (new Exception("There is no data for this report."));
                              }
                              using (DataTable dt = new DataTable())
                              {
                                  dt.Load(dr);
                                  dt.TableName = "MainReport";
  
                                  FastReport.Report report = new FastReport.Report();
                                  using (System.IO.Stream ms = new System.IO.MemoryStream(GL.Properties.Resources.rptBS))
                                  {
                                      //I put frx file as resources
                                      report.Load(ms);
                                  }
                                  report.RegisterData(dt, dt.TableName);
                                  report.FileName = "Balance Sheet";
                                  report.Prepare();
                                  PreviewControl1.AddTab(report, report.FileName);
                                  PreviewControl1.ZoomPageWidth();
                              }
                          }
                      }
                  }
              }
              catch (Exception ex)
              {
                  MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
              }
          }
  

  
  the question : who is reponsible to dispose fastreport class instance?
  FastReport.Report report = new FastReport.Report();
  
  if you click close button in fastreport previewcontrol, object report will be disposed.
  
  never ever worry about memory leaks.
  
  if you want to expose another report, create another instance :
  FastReport.Report report = new FastReport.Report();
  
  that's the answer about datasource not refreshing, create another instance of fastreport class.