Table Headings

[AntonioPerera]

Crystal 11

I have a table which contains main headings as follows :

01 Tables
02 Chairs
03 Sofa
04 Lamp

These are linked to transactions tables.

When I run the report,the report displays as follows :

01 Tables 100
03 Sofa 55

*Crystal is suppressing the null values from the transactions tables.

I want the report to display as follows :

01 Tables 100
02 Chairs 0
03 Sofa 55
04 Lamp 0

How can I achieve this ?

 

[swiss2007]

whatever join you have used from the main headings to the transactions table,make that a left outer join in the database expert,this should work.

 

[lbass]

...and also do not add any selection criteria on the transactions table, as that would in effect "undo" the left join.

-LB