Personal Payment details - cannot include Person Number
Summary
Target Bank Details report returning limited results when person number is includedContent
Hi,
I'm running a very basic query in OTBI to show the Target Bank Details for each worker. I have only 4 columns - Person Number, Target Bank Name, Target Bank Account Name, Target Bank Account Number.
However, if I include "Worker"."Person Number" I only see 30 rows of data. When I remove Person Number and only include the Target Bank information, I can see details for everyone. But I need to see the person number too so I can identify the individual its mapped to.
Any ideas on how to fix this? I have attached my XML for the report.