I have a table that shows a list of doctors, facilities, and charges. I set up a Cross-tab Report in Crystal Reports 2008, putting the doctors on the rows, the facilities on the columns, and the sum of the charges (and a couple of related numbers) as the summary fields.
When I did this same report in Excel, I had no trouble sorting by sum of charges in both directions, so that the doctors who brought in the most money were listed at the upper left, and the facilities that brought in the most money were also listed at the upper left. However, in Crystal, I could only use the Group Sort Expert to sort the doctors by sum of charges; I could find no way to sort the list of facilities at the same time.
Am I missing something, or is Crystal just lacking this basic ability? Thanks.