Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2109
  • Last Modified:

Sort a Chart by Month in crystal reports

Hi There,

I am totally new with crystal reports.  I am trying to create a chart that sorts by Month Jan, Feb, Mar etc.

I have managed to create a formula to change my date field to month but when I run the chart the months show in alphabetical order (i.e. April, Feb, Mar)

I have searched and do not understand any previous posts.

Can someone please help me.

Thanks,
0
mco32
Asked:
mco32
  • 5
  • 4
1 Solution
 
mlmccCommented:
You don't need to change the field to the month

Create the chart with the data
When you add the date field
Click the OPTIONS button
Change it to group by month

mlmcc
0
 
mco32Author Commented:
Hi mlmcc

Sorry, total new to this.

Where do I find the options button.

This is my chart options.

When I change the field to date it just outputs dates on the report


chart.jpg
0
 
mlmccCommented:
What version of Crystal?

You may have to use the ADVANCED option

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mco32Author Commented:
Think it is 8.0.1.0
0
 
mco32Author Commented:
Advanced tab is disabled also
0
 
mlmccCommented:
What formula is used for the month?

If you choose the datefield does the ORDER button become available?
If so click it and see if you have Original order as an option or Specified order

Specified order allows you to put the values in the order you want to use.

mlmcc
0
 
mco32Author Commented:
This is my month formula: MonthName(Month (CDate({Leads.lead_DateOfSubmission})))

Tried the order by box - only shows months were data is available - would I have to go in here every new month to sort the month order?  
0
 
mlmccCommented:
In CR XI when I click the ORDER button for a date I have the option to group by a time period
It is a drop down with
This Section Will Be Printed

Try changing the chart to use the date field rather than the formula and see if you have that option.

mlmcc
0
 
mco32Author Commented:
Thank you so much.

My date was stored as a string, so I coverted to a date field and the options then showed up.

Your  a life saver - Thank you
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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