Crystal Reports grouping removes data

Basicaly, when i add another item to summarize, the group is filtered. I'd like to show 0 or nothing if there is no data for the new item i'm adding.

Report images

The field i'm adding is from a different table. If i a开发者_开发技巧dd a field from the same table it seems to allow blanks

You are joining the tables using an INNER JOIN. you need to make this a left join.

If you're using the "Links" functionality you can use the Link Options dialog to set it to a Left Outer Join

If you're writing a SQL statement to join the tables you can just use a Left Join instead of an inner join