SQL Query from VS to Fast Report

Johnxp

Hi,

I have to send custom SQL query from my application to Fast Report, How Can I do that??

I set parameter in Fast Report, and I sent the sql query to this parameter from my application

report1.SetParameterValue("sqlQuery", sqlQ);

But, To what object/data/ shall I set the parameter inside Fast Report?

Thanks,

AlexTZ

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

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

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.