Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

How do I show month names on a month sorted graph in Crystal 2008

After sifting through many of these posts I managed to create the graph I need. To do this I added my date to the chart expert in the advanced layout with my data and set the order for my date field to be by month. This works, but is there a different way I can get those numbers to display? Currently they just show up on my graph as

10    11     12     1     2     3
(the data is currently filtered to show 10/10 through 3/11)


If possible I would like this to be displayed as the mm/yyyy. Thanks for the assistance.. I couldn't seem to find the answer anywhere else for this but I apologize if it is a repeat. Also, I see label aliasing, but I don't believe that will work for this circumstance..

I wonder if maybe I can check the Use a Formula as Group Sort Order box and specify a formula that will sort chronilogically as well as display the mm/yyyy?

Thanks for the help!
0
SeyerIT
Asked:
SeyerIT
  • 2
1 Solution
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If your report is grouped by month, simply customize the group options so that the group name is a formula: ToText({your_Date_field},'MM/yyyy')
Then, make the chart based on the report grouping.

Otherwise, base your chart on a CrossTab and customize the Group options in the CrossTab in the same way.
0
 
SeyerITAuthor Commented:
Thanks for the help Ido! Actually, changing the group name to a formula inadvertently fixed another issue I had, in which on the side pane "Groups" view my years were being displayed as 2,010.00 & 2,011.00 and my months were 10.00, 11.00, 12.00, 1.00, etc. That formula did fix those. I wasn't even going to dig into that for a while since I figured it would be difficult to change:)

Also determined I didn't need to create custom formulas to group my information. Group Expert can do that itself as well as sort everything chronilogically. Originally I had steered away from the cross tab report because it would let me select my criteria other than a top n. But using it in conjunction with the sub report works perfectly! Also just like you said I can create formulas for the group names in cross tab as well to make it show on the graph correctly!

Thanks again for the help! Solved several problems with this one!
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Excellent. Thanks for closing the loop.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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