My requirement is to reconcile the transactional data and the reference data. I have the reference data values in both the layouts (Transactional & Reference table). As you see my transactional layout will have duplicates for the reference data as it will repeat for different transactions. I want to create a B&R to check and confirm the reference data in the transactional data is present in the reference table. If they are there then I will flag it as PASS else flag it as FAIL.
ID RefData1 RefData2
1 a b
2 a b
3 a c
4 s d
My B&R report will have the Transactional table ID column and the status of the reconciliation.
I have defined RefData1 & RefData2 as ID columns in my control. Since the rows 1,2,3 have the same ID it automatically suppress them and gave me only 1 row in my report.
How can I make it allow the duplicate IDs achieve the report as per my requirement?
Please sign in to leave a comment.