How do I define a view with 1:M relationship and use it in report with 1:1 rolling up child table

Girish Kale shared this question 17 months ago
Answered

I have a requirement whether my view has 2 tables. 1 Parent the other child with multiple rows for a parent value.

I want the view to help me with 2 eporting needs.

1. Where i want to show the 1:M relationship in a report using the view.

2. Other where i want to group the child by each unique parent and display data. Say e.g. Display the count of children for each parent.


Can I do this with single view?


Thanks,

Girish Kale

BMC Software.

Comments (1)

photo
1

Hi Girish,

1. A good way to show the unique parent values with their multiple child values is to use the Suppress Duplicates options on the parent values column:

/wWPwGT0JHMd5gAAAABJRU5ErkJggg==

/6WawhpACp3TAAAAAElFTkSuQmCC

2. A good way to do a count of the children for each parent is to set the aggregation of the child values to Count as shown below:

/BKHvM1XMT3AAAAAASUVORK5CYII=

/6yatufIAAAAASUVORK5CYII=

regards,

David