Solved

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

Posted on 2011-03-16
3
589 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
  • 2
3 Comments
 
LVL 22

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 22

Expert Comment

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now