Skip to Content
avatar image
Former Member

Crystal Report: How to show group name with no record

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?

quu2n.png (9.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 29, 2017 at 02:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded