Report Does Not Print Parents unless they have Children.
I have a 2-tier report, that is a report with parent and child data.
The data is being supplied by a dataset with two tables.
The report has a data band, using the one table and then a child data band using the other table.
In the child data band, I put in a filter expression like
[ParentId] == [ChildsParentId]
I want the report to print ALL of the parent records, and for parents that have children, I also want to print the child records "under" (after) its parent record.
However, the resulting report only prints the parent records that have at least 1 child record. The child records print fine. But I never get any parent records that don't have children to print.
I want.
Parent1, with no children
Parent 2, with no children
Parent 3, with a child
Parent 3's child
Parent 4, with a child
Parent 4's child 1
Parent 4's Child 2.
However, for me, the first 2 parents never print.