Cross tab Sort Oder

Posted on 2014-08-27
Last Modified: 2014-08-27
Hi there,

I have a cross tab in a report that has the following rows:

Event Year
Event group
Event Name

I'd like to sort by event date after the event group field but do not want to add the field to the output of the report.  Does anyone have any ideas on how to accomplish this?

Thanks in advance,
Question by:rporter45
    LVL 22

    Accepted Solution

    Set level-3 rows in the Crosstab to a formula that combines Event Date & Name.  
    Select that level-3 row formula in the CrossTab expert, click on Group Options... button, select the Option tab, and turn on the checkbox to customize the 'Group Name Field'. Select the event name field to act the group name field.

    Author Closing Comment

    Works perfectly! Thank you!

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    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. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    730 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

    16 Experts available now in Live!

    Get 1:1 Help Now