Group Date time file by Month

[EdwinBetar]

Hi,

In Crystal Reports I was trying to produce a graph showing figures on a monthly basis. I was using a datetime field from a SQL database and extracted the month by

month(datetime)

This worked fine but on the graph the month is represented as a number 1.0, 2.0, 3.0.....12.0. How can I produce the graph so it is showing the month in words.

 

[dgillz]

Monthname(month({Datefield})) will return the words "January", "February", etc.

Monthname(month({Datefield}),True) will return "Jan", "Feb", etc. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[kenhamady]

If you group on a date or datetime field, you also have the option of grouping by month, which will show month/year, and will also put the groups in chronological order. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com