I have a group and have put it into a specified order. The field is a formula field and returns a number. My groups are ranges of this number and then in the group header I have a count of the fields that fall into this range. So for example:
Formula field values: 4, 12, 8, 9, 15
Group name: Count:
"Less than 7" 1
"7 to <10" 2
"10 to <13" 1
"13 to <16" 1
I also have another named group of "16 to <19", but in the example above there are no records thast fit this criteria, so the group name does not get printed. Is there any way to force the group name to be printed (and a count of 0). Could this be done with an extra command and an outer join?
Formula field values: 4, 12, 8, 9, 15
Group name: Count:
"Less than 7" 1
"7 to <10" 2
"10 to <13" 1
"13 to <16" 1
I also have another named group of "16 to <19", but in the example above there are no records thast fit this criteria, so the group name does not get printed. Is there any way to force the group name to be printed (and a count of 0). Could this be done with an extra command and an outer join?