>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

Try NVL() e.g.

SELECT a.field, NVL(b.character_field,""), NVL(b.numeric_field,0) ;
  FROM a LEFT JOIN b ON a.id = b.id...