CR8, Crosstab, Row Header:  Display one value, sort by another but do not display

Posted on 2006-04-06
Last Modified: 2008-02-01
(continuation of

Hello all

I have a crosstab with row headers in YYYYMM format (chr(6)), and via the formula displaying them as Aug 05, Sep 05, etc.

The only problem is, it is sorting the rows in alphabetical order, i.e. Apr 05, Apr 06, Aug 05, Aug 06, etc.

How to display the month in Apr 05 format, but keep sort order of columns in 200504 format (so it goes Apr 05, May 05, Jun 05, etc)?

Question by:Jim Horn
    LVL 28

    Accepted Solution


    I think you need to change your row field to the original field so that they sort properly.
    Once you do that in the crosstab expert, highlight the new row field and click the group options button below the row box.
    In the group options, go to the options tab, then select customize group name field, and choose the formula that reformats the value as the group name field.
    This will allow things to be sorted by the original field, but the formula will be displayed.
    Make sense?
    LVL 65

    Author Comment

    by:Jim Horn
    I was able to follow the instructions (other than in CR8 in Group Options, there is not a separate Options tab, but the controls you mentioned all existed on a Common tab), but was not able to get the formula value to display correctly when entered in the 'Group Name Formula Editor' as {formula_name};
    LVL 65

    Author Comment

    by:Jim Horn
    Disregard my first comment, I had a later formula in there.  Your comment as posted worked great.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    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. …
    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 …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now