Hi Rajesh,

If it's simply a matter of not seeing the word .NULL. in the view, try using SET NULLDISPLAY TO "". This will make fields with a null value display blank.

>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