Not all records are displaying 1

[Gweniviere]

Hi experts,

I'm using Crystal Reports 2013.

I have two tables in a one to many relationship.

Table one contains all types of errors that can be reported.

Table two contains all errors reported.

Grouping by table one displays all possible errors as expected.

Inner group with summary of counts displays number of records of specified error type found in table two.

However, when no errors of a specified type are in table two, only the error types from table one are displayed on the report.

How can I display errors types with a count of zero?

 

[LaurieHamlin]

I'm using XI so I'm not sure that this will work. I'd create a formula that counts errors and if there are no errors then 0. I hope that helps.

 

[Charliy]

change your inner join to a left outer join

 

[Gweniviere]

Thanks to both of you! I started to do what Laurie recommended, but Charliy's solution was easier and faster!

Gwen