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
79839 tuck 02/29/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 Logged
