Sorting by Date and Time

[PBS2]

I have a requirement to sort my report by Date and Time. My data has separate fields for date and time. I have figured out that if I Group Sort on the Maximum of the Date field the report displays in Date order. However, how I can sort on Time within Date ?

 

[WarrenRoss]

Not sure I understand. It sounds like you are not grouping on these date and time fields, so could you provide a little more detail on what your groups and detail looks like?

It sounds to me like a simple record sort would work just fine. Have you tried using that?

 

[Madawc]

Check Report > Sort Expert - or whatever it is on your version of Crystal. You can sort on the basis of individual record fields, including time within date.

Madawc Williams (East Anglia, UK)

 

[lbass]

Try creating a formula:

datetime({table.date},{table.time})

Then use this formula for your sort. (Remove the topN sort first).

-LB