Skip to main content
Topics#Reports & DashboardsPergunta de Dhanashri Parkar
Dhanashri Parkar perguntou em #Reports & Dashboards
18 de out. de 2018, 15:30

Perform A->B and A->C relationship in Custom: Report Types

In the 'Report Types' we have an option to create a parent-child relationship using left outer join. However, if I have three objects and I want to create this relationship: A->B and A->C What is the best way to create this type of relationship?

 

I was thinking to make it a full-outer types but the radio button in'Object Relationship' only allows the left outer join!!
3 respostas
  1. Sunil Sarilla (M&G Investments)
    18 de out. de 2018, 15:37
    Hi Dhanashri,

     

    Thats right, the report type relationship goes hiearchial.

     

    For your requirement you will need a Joined Report

     

    A Joined report is a report with multiple blocks (each block representing a report type)

     

    so in your joined report block1 will be A -> B

     

    block 2 will be A-> C

     

    you will then use a common field (which will be a field from Object A) to group the report

     

    Could you please expand on your full reporting requirement
Escrever uma resposta...
0/9000