Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group in specified order - show all group names

Status
Not open for further replies.

Katy44

Technical User
Dec 12, 2003
723
GB
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?
 
I have had to do this by getting rid of the groups completely, writing a load of formulas to return "1" at the right time, writing out the "groups" I want in the (sub) report header and then putting the formula sums next to them.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top