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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Duplicate Rows

edited May 23, 2018 8:44PM in Reporting and Analytics for HCM 7 comments

Summary

When bring multiple emails / phones, it brings them in on one line and then creates an additional line with one of the attributes

Content

UPDATE:  With everyone's help, I was able to obtain the results I was looking for.  I have attached the XML for your convenience.  Keep in mind this report has ALOT of fields, please modify your for your specific needs.

 

I have a report that originally had the primary (work) email and phone number, now they would like to incorporate personal email as well as cell phones.  I have brought in the personal email and primary email and was able to bring on one line because of different dimensions.  However, when I do, now it creates a second line for each record with the primary email only listed.  I have added the XML for this report, in hopes that someone can help me?  I only want one row with both emails and both phone numbers.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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