• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

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
0
bamoon
Asked:
bamoon
  • 4
  • 4
1 Solution
 
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
 
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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
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
 
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now