Translating dates to Months

Posted on 2012-04-02
Medium Priority
Last Modified: 2012-06-21
Good morning,

I have a report that takes date from Jan 1 to Dec 31 of the year.  From there I would like the data to be represented in the report based on month.

For example:

Jan                         Feb                        March                         April....
summary details    summary details   summary details        Summary details

Can you assist in categorizing the date/time field into months?  Any help would be appreciated!

thank you -
Question by:rporter45
  • 2
LVL 23

Accepted Solution

Ido Millet earned 800 total points
ID: 37795839
Insert, CrossTab
Drag your date field to the column area of the CrossTab
In Group Options for the CrossTab column field, select 'for each Month'

Author Comment

ID: 37795934
Thanks for the quick response, I will try this later today and get back to you,

LVL 101

Expert Comment

ID: 37795993
SOunds like the right idea.  If you need help setting it up just ask more questions


Author Closing Comment

ID: 37833792
Sorry for the delay - worked perfectly!

Thank you - cs

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question