Report onneeddatasource

[JedF]

Hello
This is my code to input data into a table on the report.
The table is linked to a objectdatasource with the same columns
When i bind to the report none of my data comes through

private void monthlyservicesales_NeedDataSource(object sender, EventArgs e)
       {
           var report = (Telerik.Reporting.Processing.Report)sender;

           using (var mySql = new MySQL(App.ConnString))
           {
               var data =
                   mySql.QueryDataset(
                       @"SELECT servicetable.Name,count(*) as Total,0 as BWTotal
                                 FROM    axxess.axstable axstable
                                      JOIN
                                         axxess.servicetypetable servicetypetable
                                      ON (axstable.ServiceTypeId = servicetypetable.ServiceTypeId)
                                      join axxess.servicetable ON servicetypetable.ServiceId = axxess.servicetable.ServiceId
                                WHERE     (date_format(axstable.DateCreated,'%Y%M') =  date_format(?0,'%Y%M'))
                                        and axxess.servicetable.Name not like '%*%'
                                    Group by servicetypetable.ServiceId
                                    order by count(*) desc",
                       report.Parameters["datetime"].Value);

               var objectDataSource = new Telerik.Reporting.ObjectDataSource();
               objectDataSource.DataSource = data.Tables[0]; // GetData returns a DataSet with three tables

               report.DataSource = objectDataSource;
           }
       }

[Steve]

Hello Jedf,

The Table item is a separate Data Item that has its own DataSource property and respectively its own NeedDataSource event. Also note that you should create the entire table definition with corresponding expressions for the TextBoxes e.g. = Fields.MyField1. The columns of the Table would not "autogenerate" based on the provided data source.

Kind regards,
Steve
the Telerik team