private
void companyBooking_NeedDataSource(object sender, System.EventArgs e)
{
Telerik.Reporting.Processing.
Chart companyBookingChart = sender as Telerik.Reporting.Processing.Chart;
companyBookingChart.DataSource =
this.bokadoktornDataSetTableAdapter1.GetData();
}
In the InitializeComponent()-method I have this eventHandler.
this.companyBookingChart.NeedDataSource += new System.EventHandler(this.companyBooking_NeedDataSource);
This is my database-sqlquery, (Works fine)
SELECT YEAR(BookedDate) AS Year, MONTH(BookedDate) AS Month, CONCAT(u.FirstName, ' ', u.LastName) AS FullName, Count(*) AS NoOfBookings
FROM Bookings b
INNER JOIN Users u ON u.Id = b.BookedById
INNER JOIN CompanyUsers cu ON cu.Id = u.Id
WHERE cu.CompanyId = 1
GROUP BY u.Id, MONTH(BookedDate), YEAR(BookedDate)
ORDER BY NoOfBookings DESC;
When I preview my report nothing happends. I dont know why, everything worked fine until I added my chart. Is it something wrong with my NeedDataSource-method.
Thanks
/Emil