Crystal reports 10 - How to sort a group parameter field from A-Z

[lbass]

You need to format the date, which is a string. So how does it currently display? MM/dd/yyyy? Or what is the format?

-LB

 

[belle99999]

Thanks!!...

well I actually went back into the database and updated my script..

TO CHAR

and refreshed the report and now the report date looks great 01/12/2011

but this field is part of a group parameter so when a user selcts to group by seniority date it poulates in the report but not ascending at all.

 

[belle99999]

so before I updated my script the filed in the databse was

01/12/2011 00:00 00PM

now its

01/12/2011

so after refreshing the crystal report the date formatted correctly but couldnt get the field to sort A-Z

is it probaby something I need to do within the group parameter?

 

[lbass]

So is that December 1 or January 12? dd/MM/yyyy or MM/dd/yyyy?

-LB

 

[belle99999]

thats

dd/mm/yyyy

sorry

 

[lbass]

Replace your string date with the following formula:

stringvar sdt := {CW_VW_209_SEN_CALLIN_SHEET.SENRTY};
totext(date(val(mid(sdt,7)),val(mid(sdt,4,2)),val(left(sdt,2))),"yyyy/MM/dd")

This will result in the correct sort.

-LB