Sort

[chrisssyp82]

Crystal 2008

Hi I have a report which is grouped by SchemeID. Within this group are transactions grouped by TransID, so obviously this lists the transactions in TransID order beneath SchemeID.

What i want to do is for a particular SchemeID, say 715, instead of it grouping and listing in TransID order, I want it listed in RetailID order, but keeping the TransID order for all the other SchemeID's.

Was wondering if this was possible, and how i could go about it?

Thanks

Chris

 

[Madawc]

You could do it with a formula field, e.g.

If SchemeID = 715
then RetailID 
else TransID

For grouping, replace TransID with @GroupField

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[chrisssyp82]

Works perfect.

Thank you very much.