Crystal Reports - Removing duplicates in 2 data fields
Clash Royale CLAN TAG #URR8PPP Crystal Reports - Removing duplicates in 2 data fields I have 2 data fields base on 2 xml files in my Crystal Report. First data field is - EXP TRANSID EXPID PAYMENT MONTH trans01 exp01 1,000.00 JANUARY trans02 exp02 2,000.00 JANUARY Second data field is - FEE TRANSID FEEID PAYMENT MONTH trans03 fee01 3,000.00 JANUARY trans04 fee02 4,000.00 JANUARY trans05 fee03 5,000.00 JANUARY My expected output is this: (I want this to happen) For the month of: January EXP FEE TRANSID EXPID PAYMENT TRANSID FEEID PAYMENT trans01 exp01 1,000.00 trans03 fee01 3,000.00 trans02 exp02 2,000.00 trans04 fee02 4,000.00 trans05 fee03 5,000.00 Is this possible? Thanks in advance! But the output is this: For the month of: January EXP ...