Sorting dates in Crystal reports

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
BenvorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UnifiedISCommented:
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).
0
BenvorAuthor 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
0
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

UnifiedISCommented:
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.
0
UnifiedISCommented:
You'll end up with a formula that looks like this:
{tbl.Date} in {?date1} to {?date2}
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CodeCruiserCommented:
That does not sound like you need to do SORTING in your report as is the original question!
0
BenvorAuthor Commented:
Sorry for the misleading description..............
0
BenvorAuthor Commented:
Thanx allot UnifiedIS. Now My program is finished at last. Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.