Show groups with no records

[springle]

I am making a report that tell how many clients fall in an age category such as 10-20, 21-30, etc. When there are no clients in that age category then the report does not show that group at all so the report appears to skip an age range rather than show a count of 0 for that group.

How can I make these empty groups show up as 0 records and ultimately display in a chart.

Thanks in Advance,
Scott

CR9 Pro

 

[lbass]

One approach would be to insert conditional formulas for each age group, as in:

//{@10to20}:
if {table.age} in 10 to 20 then 1

//{@21 to 30}:
if {table.age} in 21 to 30 then 1

Then in the report footer you can insert a chart, choose "for all records", and add each formula into the summary area, using sum as the summary.

If you have row inflation, you will need to use running totals instead of conditional formulas.

-LB

 

[springle]

What do you mean by "row inflation"?

Scott

 

[lbass]

Sometimes table joins cause values to repeat so that using a formula that adds one per record would give an inaccurate total. In that case, running totals must be used so that unique records are summarized. If your totals are correct using the above method, then you are all set.

-LB

 

[springle]

Gotcha. Actually it is a one to many field but what I am doing is summarizing the primary key by distinct count. I will try making a formula field that holds that value of 0 if empty and display/chart of that formula.

Thanks again,
Scott