Amendment need to an existing report
Summary
Multiple NationalitiesContent
Hi,
How can I modify the attached report so that only the primary nationality is displayed?
For context, there are many employees that have double / triple nationalities and I don't want multiple lines of data to show in the report?
Is it possible to just show 1 nationality (preferably their primary nationality)?
I understand that BI Publisher can get around this problem because it can create multiple columns e.g. Nationality 1, Nationality 2, Nationality 3 and so on - will this ever be possible to do in OTBI? I have so many reports where home & work addresses, phones numbers and emergency contacts are creating sometimes 7/8 lines of data for a single employee.