Print Page | Close Window

Original Order Reseting

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11905
Printed Date: 05 May 2024 at 6:38am


Topic: Original Order Reseting
Posted By: Boydus
Subject: Original Order Reseting
Date Posted: 20 Dec 2010 at 4:58am
Dear all,
 
I'm working in Crystal 9 on some reports.  The reports lists percentages in month order for the previous 12 months.  It uses a formula field to work out the order and then uses groupings to display the results in the correct order.
 
On the graph however, once I say and reopen it the order reverts back to alphabetical order of the name of the month despite it being set to "Original Order" so it follows the same pattern as the grouping.
 
Has anyone else had this happen?  Is there a way around it so that I don't have to sort by a "specified order"?
 
Cheers
 
Boyd Livingstone


Replies:
Posted By: DBlank
Date Posted: 20 Dec 2010 at 9:48am
is there a reason you are not just grouping on the date field set to a month? This will order it by date automatically.

Posted By: Boydus
Date Posted: 20 Dec 2010 at 10:23pm
The data in the database I'm querying does not have date fields.  The month is entered as "January","February" etc...  and the year is another field.

Posted By: DBlank
Date Posted: 21 Dec 2010 at 3:41am
maybe you can convert the original data into a date field and use that for grouping
perhaps
cdate(monthfield + " 1, " + yearfield)

Posted By: Boydus
Date Posted: 23 Dec 2010 at 4:54am
Thank you.
I've had to change the formula to:
 
CDate ( mailto:%7b@calendar - CALENDER_YEAR }, iif({MONTH_ID}=9,12,({MONTH_ID}+3) mod 12), 1) as it's UK data format and the MONTH is vased on financial year.
 
Unfortunately the axis of the table are not now displaying correctly, and the format fields are greyed out.  Any ideas?

Posted By: DBlank
Date Posted: 23 Dec 2010 at 5:10am
is the graph using the new formual field set to group by month?

Posted By: Boydus
Date Posted: 23 Dec 2010 at 5:26am
yes

Posted By: DBlank
Date Posted: 23 Dec 2010 at 6:03am
what type of chart is it?
how does the label currently look and what do you want it to look like?

Posted By: Boydus
Date Posted: 23 Dec 2010 at 10:19pm
It's a Bar Chart - it now has the date on the x axis as 01/03/2010.  I need to show it as March 2010

Posted By: DBlank
Date Posted: 28 Dec 2010 at 5:01am

I am not seeing anyway to get it exactly they way you want.

If you conver the string into YYYY - MM - MONTHNAME it would stay in order but not sure if this is acceptable or not.

Posted By: Boydus
Date Posted: 03 Jan 2011 at 10:00pm
No, it's got to be just the month and year in that order (strict instructions from the client on this)


Print Page | Close Window