Show fields with zero value

[jansan]

As discussed before (http://www.codeguru.com/forum/archive/index.php/t-307131.html) CR does not show record that is zero.

However, I need to show records that is zero both in graphs and in cross tabs. Could someone please help me?

I'm using CR XI.

[Madhi]

What do you mean by "Record is zero"?

[jansan]

Example: I shall show how many outstanding tasks each department has, and I also need to show which departments that has no (i.e. zero) outstanding tasks. I need to show this in a graph.

Thanks for your help!

Jan

[planbe]

You need to have an outer join to a table containing one record per department to ensure all departments are included.