There are 2 ways to achieve this 1) You can convert the date time to date in sql query iteslef and create a group of that field in the report and pass the date field to the chart rather then datetime. 2) Other way to achieve this if you can not change the query, in that case create a new variable and convert the datetime field to date datatype and then use that variable for grouping and passing to the chart Regards Honey