Report to place dates in correct month column for each record

I need to use crystal 11 to place the date associated in each record under the appropriate month header as follows.
Milestone Desc         Jan          Feb          Mar        Apr           May           Jun           Jul           Aug......
MS No 1                                                                               5/15/07
MS No 2                                                                                                  6/15/07
MS No 3                    1/1/07
bamoonAsked:
Who is Participating?
 
ThomasBallardITCommented:
Create a formula and in that formula do something like this.

if date starts with "1" then "January" else
if date starts with "2" then "February" and so on.
0
 
ThomasBallardITCommented:
Looks like you want a crosstab, sir.  
0
 
ThomasBallardITCommented:
Row would be your dates, and Column would be your months.  Doesn't look like you will be summarizing anything.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
bamoonAuthor Commented:
Columns will be your months? How do I populate this?  Do I need to build another table with each month in it?
0
 
bamoonAuthor Commented:
I need all the months of the year not just the months populated from the date is the table, and Crystal doesn't seem to like null values.
0
 
ThomasBallardITCommented:
What's not showing right?  Is it leaving off months that have no data in them?  
0
 
bamoonAuthor Commented:
Yes
0
 
bamoonAuthor Commented:
Your solution worked after I changed the dropdown in the formula workshop to Default Values for Null.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.