Skip to Content
0

Crystal Report: How to show group name with no record

Mar 29, 2017 at 01:34 PM

22

avatar image
Chan Sophia

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)
SAP Crystal Reports
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Ian Waterman Answered Mar 29, 2017 at 02:01 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users