2 Replies Latest reply: Sep 9, 2011 5:25 PM by 887365 RSS

    Combined Reports - How to display results in single row

    878041
      Hello,

      I have created a report by combining two subject areas (Account Contact History and Account Team History). But in the result instead of one row i am getting two rows like: one row from the Account Contacts History and the another row from Account Team History.

      Example:

      We took
      4 fields (Account name, Account Type, Location, Contact Lastname) from Account Contact History and
      2 fields (Lastname, Team role) from Account Team history.

      we are getting output like:

      Account Name | Account Type | Location | Contact Lastname | Lastname | TeamRole
      ---------------------------------------------------------------------------------------------------------------------
      Account Name | Account Type | Location | Contact Lastname | _______ | ________
      Account Name | Account Type | Location | ______________ | Lastname | TeamRole



      Can anyone please tell me how to make the result in a single row. I have used Union set operation between the two criterias.

      Thank you,
      Hari