Report Grouped by Date (CLOSED)

[divined]

Hello everybody

I`m using Crystal Reports 10. Currently, I`m trying to create a simple two table report grouped by Date. Using the Report Wizard I only tell it to use two Descriptive fields from each table and to group them by date.
The grouping does occur, but the dates on which the groupings are based seem to be rather randomly selected, or in a way I can`t understand. How can I tell Crystal Reports to make a group for each day or each month?

thx, in advance

George Papadopoulos

[canceriens]

I do not know about the real criteria of ur report but as u have written u r selecting data from two tables so first of all u must have to link the Date feild of both tables then from the Insert Menu click on Group in Insert Group dialouge select ur feild on which u want to Group ur report and to Group ur report on a particular Month u'll need to create a Formula in Feild Explorer > Formula Feilds give any understandable name to the Formula.

Then click ok nd write this line in ur Formula

Month({vwBPBooking.SDATE})
Month({at here u'll use ur Date Feild name})
it would return Month Number (3 for March)

nd now this Formula would be appearing in ur Insert Group dialouge u can Group ur report by this Formula (Group by Month)

if you want to change month number to the Month Name its function is as follows.

MonthName(Month({vwBPBooking.SDATE}))
MonthName(Month({at here u'll use ur Date Feild name}))

I hope it would be the answer.
have fun with crystal reports ;) enjoy.................