Solved

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

Posted on 2011-03-16
3
626 Views
Last Modified: 2012-05-11
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
Comment
Question by:SeyerIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 35148733
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
 
LVL 2

Author Comment

by:SeyerIT
ID: 35155950
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
 
LVL 23

Expert Comment

by:Ido Millet
ID: 35155995
Excellent. Thanks for closing the loop.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

689 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