You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to put the information into one row and limit the duplications?

Received Response

Hi All,

I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information as well. I want to be able to keep the staff records into one row as much as possible (exceptions where they have multiple same contact phone number type or multiple emergency contact is fine to display on more than one row but otherwise should be shown in a single row if they have one work phone number, one personal landline etc).

In my report that I build I have created the custom columns for personal landline, personal mobile phone, work mobile phone, and work landline. What it currently does is, it will show the person on multiple rows even if they have just one work mobile number and one personal number. It does this by having one row showing the personal mobile phone and the work phone blank, then another row to show the work mobile but the personal mobile blank (will have more rows if they have other phone types). For this case I would want it to show on

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!