MonthName function returns "Others" for November and December ????

[xp8103]

I must be missing something. I'm in Crystal 9.
I have a cross tab report that has month names as column headings derived from meeting dates in a SQL table. The date field is a smalldatetime and I have a formula that derives the month name from the date:
MonthName (month({Command.meeting_date}))

For all the months January to October, the formula correctly puts up the month names. The rows in the table are the days of each month where there was a meeting. Working with test data and putting meeting dates in for each month I can watch Crystal build the cross tab with each iteration. But when it gets to November and December dates (regardless of how many month columns come before - some months have no meetings) it puts up a column labled "Others" and puts all November and December dates in there?? I have put the raw meeting date field and the monthname formula into the detail line of the report and it correctly identifies all the month names for each meeting month, including November and December. But when that SAME forumla is included in the column heading, it's "Others".
HELP!

 

[lbass]

Did you use "specified order" in the crosstab? When you first set this up, you have to run the report with all months, so that you can order all months in the specified order screen--otherwise they will be clustered into an "others" category.

If you had used the datefield for your crosstab, you wouldn't run into this problem--it would be correctly ordered. You would go to group options (in the crosstab expert) and choose "print on change of month" and then choose "customize group name"->use a formula->and then enter your monthname formula there.

-LB

 

[xp8103]

Ah HA! Well, I didn't actually create the report, but it was likely created in November, before any meeting dates would have been entered and therefore likely not available when test data was generated. It is possible that the specified order wouldn't have included November and December and therefore they got clustered.

 

[xp8103]

Yep! That was it! The "specified order" only ran thru October. Thanks! learn something new every day.