Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Date Field not showing in the right order Post Reply Post New Topic
Author Message
moontide
Groupie
Groupie
Avatar

Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Quote moontide Replybullet Topic: Date Field not showing in the right order
    Posted: 22 Jul 2011 at 4:09am
I have a report that a date field in it with a parameter where we enter start date to end date. the start date is '01/01/2010' and the end date is '05/29/2010/ and i am trying to pull certain structure info during this time frame and i grouped the date field and also sorted it both desc and asc order but to no avail the dates are still not in the right order. e.g.
 
below is what its showing:
 
Struc ID      Name       Date
 
18290        build         01/01/2010
38921        pass         01/23/2010
59872        block        01/13/2010
69985        ssss         02/17/2010
79839        tuck          02/29/2010 
89834        fffff           03/15/2010
92100        wiwi         03/25/2010
95000        rtryyy       03/14/2010
 
 
 
below is what i want to see
 
Struc ID      Name       Date
 
18290        build         01/01/2010
59872        block        01/13/2010
38921        pass         01/23/2010
69985        ssss         02/17/2010
79839        tuck          02/29/2010 
95000        rtryyy       03/14/2010
89834        fffff           03/15/2010
92100        wiwi         03/25/2010
 
the 'struc ID' and 'date' fields have been grouped to show the data in order. I have grouped the 'date' and put it above the 'struc ID' group, but the date fields are still not showing in the right order. Is this problem due to the grouping or table links or any formula? Any ideas you guys could shed would greatly be appreciated! Thanks in advance 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 Jul 2011 at 4:12am
does the order by list "date" first?
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 25 Jul 2011 at 12:34pm
Have you tried just sorting "a to z" on the date field?
IP IP Logged
moontide
Groupie
Groupie
Avatar

Joined: 23 Feb 2011
Online Status: Offline
Posts: 78
Quote moontide Replybullet Posted: 26 Jul 2011 at 2:02am
Thanks guys!...I found the solution. I removed the groups and just sorted the date field instead.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.