Print Page | Close Window

Crosstab Question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22870
Printed Date: 25 Apr 2024 at 5:38am


Topic: Crosstab Question
Posted By: RayMilhon
Subject: Crosstab Question
Date Posted: 22 May 2020 at 6:34am
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



Print Page | Close Window