Report from Child table

[ritasikka]

Hi ,

If i try and build a report to include fields from Child table and then dot walk to the parent to include the field from Parent table , will that work in order to get fields from both the tables in my list view ?

[Adrian Ubeda]

Hi Ritasikka,

That will work. Build a report for your child table and the use parent reference for dot-walking into parent's fields. Here's an example with sc_req_item table and sc_request, when creatin a report inside configuration > choose columns and then select the columns that you want to show as you were working with list layout.

[Saurav11]

Hello,

Yes you can do that for example let's take example of incident and child incident

 You create a report on Incident table and have filter parent is empty. 

And then add all the fields and parent field from the column

Please mark my answer as correct based on Impact.