Forgot password? | Forgot username? | Register

Charts/Cross-tabs - include groups with no matches

Charts/Cross-tabs - include groups with no matches

Hi

Does anyone know how to force Crystal to include null groups - i.e. groups with no matching records? Even if only in Charts/Cross-tabs?

Example, I'm building a report from Catalogue module to show how many works are in a particular room (including inside holders in the room), grouping by object type (Work, Frame, Crate, Auxiliary Element) and length of stay in that location (1 year +, 6 months. 3 months, 1 month, 2 weeks, 1 week, 2 days).

I'd like to include a graph or cross-tab that will count each Object Type for each length of stay. But if there are no Crates in the data set I don't see that group. What I want to is see the group with a zero count. Same for the length of stay groups. At the moment, if there are no matches in the "3 months" group, that group doesn't show - when I want to see a zero count for that group.

In other systems I've used a "report NULL as zero" setting - but I can't see this in Crystal or EMu.

Any ideas?

Mark Bradley – Assistant Registrar, Documentation (EMu)
National Gallery of Australia

Mark Bradley
Assistant Registrar (EMu Guy)
useravatar
Offline
147 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Charts/Cross-tabs - include groups with no matches

Hi Mark,

This might help.  Going into File > Options > Formula Editor, if you look at the bottom right , you will see a box called "Null Treatment".  Try changing it to "Default Value for Nulls".  That might generate the data you want.

Or, under File > Options > Reporting look in the Reading Data section and try one of the "Convert ... NULL Values to Default" options.

Regards,
Deb



Edited by: - 13-May-15 12:38:29

Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic

Board Info

Board Stats
 
Total Topics:
601
Total Polls:
0
Total Posts:
1362
User Info
 
Total Users:
827
Newest User:
Marcus Swann (Axiell Melbourne)
Members Online:
0
Guests Online:
212

Online: 
There are no members online