Graphing Question - Group by Month

rbuser

Hi, we're using Report Builder 6 with TeeChart 5 and was wondering how we
could produce a Query that we could group by month on the X-Axis.

The date comes in a standard Date Type and we want to produce a graph so
that only the Months are shown - ie: JAN FEB MAR APR MAY ... DEC

Any help here would be greatly appreciated as currently becuase of the date
format (dd/mm/yyyy) we are unable to group on mm/yyyy.

Thanks in advance.

Regards,
Nigel Huband.

digitalmetaphors

You should be able to create a calculated field on the query for the month,
and then group on the calc field. The calculation will vary depending on
your db vendor.
In the SQL SELECT clause, say something like EXTRACT(Month FROM MyDateField)

Cheers,

Jim Bennett
Digital Metaphors