Using Crystal Reports 8, how can I format the report so that I can group by Patient ID, LastName, FirstName. I have the ff columns to report on - patient id, lastname, firstname, equipment used and am able to generate the report but on several patients more than one piece of equipment is used -
0000XXXXX Patient 1 Wire .035 Fixed J 145cm
0000XXXXX Patient 1 Multi-pack JL4, JR4,Angl Pig 6Fr
0000XXXXX Patient 1 Left Heart Kit
How can I suppress the printing of the patient id, lastname, firstname for succeeding rows for the same patient? I've tried grouping in CRW but all it did was sort the records. Ideally, the report would look like -
0000XXXXX Patient 1 Wire .035 Fixed J 145cm
Multi-pack JL4, JR4,Angl Pig 6Fr
Left Heart Kit
0000YYYYYY Patient 25 Wire .035 Fixed J 145cm
12
Anu help would be greatly appreciated
IP Logged
