Crystal Report: How to show group name with no record

[Former Member]

Hi, I start using Crystal Report recently. Some problems with the group with no records.

Let say I create a group by the department code and account code.

However, there is no data for "ME" and "MR" analysis code and the group name could not be displayed. Is there any formula could be added in order to show all the group names even there is no data for some of them?

[Former Member]

If you have a table which simply has a list of Department codes then you can add that table and the left join all other data off that table.

Make sure your dept group uses field from that table.

You will then always get a list of departments irrespective of whether there is data or not.

Ian