Formula needed to group report

[Jonesxx]

Hi,

I am using Crystal v 8.5 and I am writing a report based on the Sales table.
The problem is I am using a date/time field in the report {Sales.Date} which displays the data as
10/07/2006 00:00:00

I am only interested in viewing the date so I used the formula: date {Sales.Date} which worked fine. Now I want to group the data by month.

I tried to create a formula to do this using the subscript operator as follows: ({Sales.Date} [4 to 5]) and then my intention was to create a case statement to display the months and group the report based on this. However I am getting the message

‘A string or an array of values is required here’

Any ideas

Thanks v m

 

[dgillz]

There is no need to write a formula, just format the field in question.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[lbass]

Insert a group on your datetime field {sales.date}. On this screen, you will have the option "The section will be printed for:". Choose "for each month".

-LB