RegisterData not working

Comments

• Servitux

  August 2016 edited 12:01PM

  Try this instead RegisterData:
  

  string DataSourceName = "your_datasource_name";
  string SQLQuery = "Your new SQL Query";
  
  TableDataSource table = (TableDataSource)report.GetDataSource(DataSourceName);
  table.SelectCommand = SQLQuery;
  

  
  You can get the query used to design the report and change the sql query.
• Wesley

  August 2016 edited 12:01PM

  Servitux wrote: »

  Try this instead RegisterData:
  

  string DataSourceName = "your_datasource_name";
  string SQLQuery = "Your new SQL Query";
  
  TableDataSource table = (TableDataSource)report.GetDataSource(DataSourceName);
  table.SelectCommand = SQLQuery;
  

  
  You can get the query used to design the report and change the sql query.

  
  I'm not happy wiht this solution, because other class is responsible to create the sql command.
  There are other topic with the same problem without answer. The fast report staff don't look to the forum?
  
  
• Servitux

  August 2016 edited 12:01PM

  Wesley wrote: »

  Wesley wrote: »

  Try this instead RegisterData:
  

  string DataSourceName = "your_datasource_name";
  string SQLQuery = "Your new SQL Query";
  
  TableDataSource table = (TableDataSource)report.GetDataSource(DataSourceName);
  table.SelectCommand = SQLQuery;
  

  
  You can get the query used to design the report and change the sql query.

  
  I'm not happy wiht this solution, because other class is responsible to create the sql command.
  There are other topic with the same problem without answer. The fast report staff don't look to the forum?

  
  Have you tried to remove your data source from report, and add the new after?
  
  I think the staff doesn't see this forum...
• Designsbyray Ohio, USA

  August 2016 edited 12:01PM

  I know this is hack but you can remove the data sources from the report, in the designer, once you have finished creating it. That way it can't make any database calls you added for testing. As long as the data is registered with the correct name the report engine will still work correctly.
  
  If you have relations in the report you would need to open the report in a text editor and manually remove the connections leaving the relations intact.
  
  There is a way to edit the report file source to leave the DataSources usable in the Editor without the actual database connection being present. I can try to elaborate if interested. Keep in mind it falls under the hack category as well.
• Kang

  September 2016 edited June 2017

  I'm not happy wiht this solution, because other class is responsible to create the sql command.
  There are other topic with the same problem without answer. The fast report staff don't look to the forum?
  
  
  magento 2 seo suite
• ipong

  October 2016 edited 12:01PM

  Do not use report designer to create datasource.
  
  All you have to do :
  
  1. You have blank frx file as a template, open designer.exe , save as blank_report.frx
  
  2. Create a code in .net application
  

  using (OleDbConnection cnn = new OleDbConnection(@"........"))
  {
      cnn.Open();
  
      using (OleDbCommand cmd = new OleDbCommand())
      {
          cmd.Connection = cnn;
          cmd.CommandType = CommandType.Text;
          cmd.CommandText = "..........";
  
          using (OleDbDataReader dr = cmd.ExecuteReader())
          {
              using (DataTable dt = new DataTable())
              {
                  dt.Load(dr);
                  dt.TableName = "MainReport";
  
                  FastReport.Report report = new FastReport.Report();
                  report.Load("blank_report.frx")
                  report.RegisterData(dt, dt.TableName);
  
                  //YOU CAN REMOVE AFTER FINISH WITH THE DESIGNER
                  //IN DESIGNER WINDOW, YOU CAN PREVIEW THE REPORT BECAUSE
                  //DATA FROM DATABASE IS REGISTERED
                  report.GetDataSource(dt.TableName).Enabled = true;
                  FastReport.DataBand dataBand = (FastReport.DataBand)report.FindObject("Data1");
                  dataBand.DataSource = report.GetDataSource(dt.TableName);
                  report.Design(true);
  
  
                  //UNCOMMENT AFTER FINISH WITH THE DESIGNER
                  //report.FileName = "My Report";
                  //report.Prepare();
                  //PreviewControl1.AddTab(report, report.FileName);
                  //PreviewControl1.ZoomPageWidth();
              }
          }
      }
  }
  

  
  3. After finish with report designer, save the frx file
  4. Comment / Uncomment code above
• Kang

  June 2017 edited 12:01PM

  Yeah....
  

  ---

  Mageplaza Magento 2 Seo
• alxmark

  January 2019 edited 12:01PM

  Oh... It's finally working!
  

  ---

  Magento 2 Seo
• cherley

  December 2022

  How to show fast report in other Form when save finished. Example I design Form1 a report, but I want show Form 2. How to do?? thanks
• cherley

  December 2022

  https://forum.fast-report.com/en/discussion/comment/36560#Comment_36560

  How to show blank_report.frx at other form???