I have a view which links 3 tables A B C.
A is the header
B is child table
C is child child table

The view selects all fields and creates one record per in A and releated records in B and child records in C if any.
If there are no child records in C all the fields are show NULL.
If I use this view in report all the total fields fail asn .NULL. any thing is .NULL.

Rajesh