I have a crosstab Report That needs the following format
Cost Commercial Exchange Senior
Auth OP $200.00 $ 0.00 $400.00
ER OP $500.00 $100.00 $175.00
Auth IP $ 0.00 $ 0.00 $800.00
ER IP $ 0.00 $ 0.00 $ 0.00
Total $700.00 $100.00 $1375.00
The issue is that in Crystal it sorts it Alphabetically. I have a field called sortorder to sort it correctly but since it's a cross tab Report how do I sort it by the sortorder but display the Cost Field
