fix sorting in my report

[Bodrum81]

Hello, I have a problem with my report.

I have create a report which shows me a Work-plan

But I have to show this report in a special sorting.

Now my Report is like that:

work Mo Tu Wed
PKF Hans Peter .. ..
PKM Jürgen lippe .. ..
PKS Manfred karl .. ..
RKF Hans meyer .. ..
RKM Detlef bier .. ..
RKS Georg burg .. ..
SRF Jochen blum .. ..
SRM .. .. ..
SRS .. .. ..

But I want to show the report like that:
The report shoud be sortet by early (F) middel (M) late (S).

work Mo TU Wed
pkF Hans Peter .. ..
rkF Hans meyer .. ..
srF Jochen blum .. ..
pkM Jürgen lippe .. ..
rkM Detlef bier .. ..
srM .. .. ..
pkS Manfred karl .. ..
rkS Georg burg .. ..
srS .. .. ..

You can define in Crystal Reports special/fix sorting
I hope you can help me.

ManagerReci

 

[synapsevampire]

Create a formula to sort on:

mid({table.work},3,1)

Depending upon your version of Crystal (you should post technical information) you would use Report->Sort and select this formula to sort on.

-k

 

[Bodrum81]

Hello.
thanks for the answer.

I have one more problem with my report.
I want to group the "works".

for example pkF, rkF, srF are in Part 1 (group one)
and pks, rkM, etc. in Part 2 (group two)

Is there a function to define the content/body of a group?

 

[Madawc]

In Crystal 8.5, you could create a formula field that tests the values of 'works'
if {works} in ["pkF", "rkF", "srF"] then "Group One"
else if {works} in ["pks", "rkM""] then "Group Two"
else "Other"

Then group using this formula field, with values of works sorted within it using the formula synapsevampire gave you.

Madawc Williams
East Anglia, Great Britain

 

[Bodrum81]

great
it works



thank you