We help IT Professionals succeed at work.

Sorting dates in Crystal reports

326 Views
Last Modified: 2013-11-26
Hi Experts

Can anyone please help me out with a sorting in my crystal reports? I have to sort the report from #date1# to #date2#. But I don't know how to and can't find something on the web

Any help would be greatly appreciated

Thanx in advance
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Are date1 and date2 different fields or do you need to sort by one date field?
To sort by one, either add a group for the date or use the sort expert (the a z icon from the crystal toolbar in VS).

Author

Commented:
I have 2 parameter fields, Date_From + Date_To and when form loads, the report must only be the dates between this 2 dates
You need to use the select expert (icon looks like a hand picking up circles).  Choose your date field and then set it to "is between" and then choose your parameter dates as the two options.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
That does not sound like you need to do SORTING in your report as is the original question!

Author

Commented:
Sorry for the misleading description..............

Author

Commented:
Thanx allot UnifiedIS. Now My program is finished at last. Thank you
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.