Skip to Content
0

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

Aug 16, 2017 at 07:06 AM

23

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Aug 17, 2017 at 10:33 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded