2. Suggestions
  3. Charts for Reports
This topic is locked

Charts for Reports

 		12/21/2007 4:50:46 AM
Suggestions
R
 r.j.pieper author

I would be very very happy, if you can make it possible to define Charts for Reports, so that i can have Charts i.e grouped by date and aggregated for years, month, week and so on.
Rgds Roland
I use AspRunnerPro (because ASPRunner.NET seems to be very very new ;-)
Sergey Kornilov admin 12/22/2007

Robert,
charts are for data. This means you use a GROUP by SQL query as a chart source.
R
 		r.j.pieper author 12/22/2007

Thanks for you reply - I will try.
Can you give me a hint which query i have to use to group by date with an interval of weeks or month ?
Rgds Roland
Sergey Kornilov admin 12/26/2007

You need to use one of date functions to get the month part and group by this part. It all depends on what kind of database you use. Check date functions section in your database manual.
In SQL Server and MS Access you can use DATEPART function for this purpose.