Skip to Content
avatar image
Former Member

How can I put the days and dates in order from a Crystal Report?

This is the issue I'm having trouble moving the THU 3/8/18 in front of the FRI 3/9/18

heqwu.jpeg (5.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 17, 2017 at 10:33 AM

    Hi Diamond,

    Assuming this is a Crosstab, here's what you need to do:

    1. Use the 'Date field' as the first column in the crosstab.

    2. Open the Crosstab Expert > highlight the first column field > Group Options > Make sure the field is set to 'Print for each day'.

    3. Go to the Options tab > Click Customize Group Name field > Click the formula button beside 'use a formula as group name' and use this code:

    totext({Date Field},'ddd')

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded