How do I define a view with 1:M relationship and use it in report with 1:1 rolling up child table
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?