Report

[economic]

Created a report using crystal report 11 (ACCPAC 5.5)

When Add a field which is null in some items ( vendor item )
the report only print items which this field has a value , does not print it if field is null.

then Created a formula field as

If Is Null ( field ) then "test1' else "test 2" and use it instead of the field

and selected defualt value for nulls

still the report only print items with a value in the field

Selected the report options "Convert other null values to deffault " still the same

Any suggestions

Thanks

EEM

 

[ettienne]

If you want to show all items including those without vendor information then you need to use a left outer join between ICITEM and ICITMV, or use a subreport for the vendor information.