SQL Query from VS to Fast Report

Comments

• AlexTZ

  November 2008 edited 9:56AM

  You need to do the following:
  - run the designer
  - select the "Report" object (in the "Properties" window)
  - switch to events and create the "StartReport" event handler
  - write the following code in it:

        TableDataSource data = Report.GetDataSource("Products") as TableDataSource;
        data.SelectCommand = (string)Report.GetParameterValue("my param");
  
• Johnxp

  November 2008 edited 9:56AM

  Hi,
  
  I did as you said but I got no error, just the application halt:
  
  
  report1.Load("calllogs.frx"); //load the report
  string sqlQ = createSQLStatement(); // this will create SQL query
  FastReport.Data.TableDataSource data = report1.GetDataSource("myTableName") as FastReport.Data.TableDataSource;
  data.SelectCommand = (string)report1.GetParameterValue(sqlQ);
  report1.Show();
  
  Is there is something wrong in this code??
  
  
  
  
  
  
• AlexTZ

  November 2008 edited 9:56AM

  Strange, it works well for me. One important note: the query defined in the report must have the same data columns. I.e. you may change the "where", "order by" conditions, but don't change the "select" - in this case the query will return the different set of data columns, and report will stop work.