Crystal Reports - Removing duplicates in 2 data fields
Multi tool use
Clash Royale CLAN TAG#URR8PPPCrystal 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 FEE
TRANSID EXPID PAYMENT TRANSID FEEID PAYMENT
trans01 exp01 1,000.00 trans03 fee01 3,000.00
trans02 exp02 2,000.00 trans03 fee01 3,000.00
trans01 exp01 1,000.00 trans04 fee02 4,000.00
trans02 exp02 2,000.00 trans04 fee02 4,000.00
trans01 exp01 1,000.00 trans05 fee03 5,000.00
trans02 exp02 2,000.00 trans05 fee03 5,000.00
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
