Force sub-summ fields to print zeros

[gmrobbie]

Hi

My boss wants our AR report to look like the reports generated by an old system, so...how can I force number fields in a sub-summary to print even if they are zeros? There must be an easy way to do this, but there isn't enough coffee in San Diego today. Thanks all.

G

[Robert Kidd]

If you number fields are calcs then I suspect "do not evaluate if all referenced fields are empty" is checked. Unchecking should force the calc to show zero's.

If your number fields are "just" number fields then try auto entering 0 in the field definition.

If your fields are summary fields then you need to force a zero into the fields it is summarizing using one of the above methods.

Also check you have not formatted the field on the layout not to display if number zero !

[gmrobbie]

Thank you Robert for your reply. I have checked all the suggestions you made in your message...my problem is that the aging report prints out the amounts receivable by the age of the invoice (30, 60, 90, etc); if a specific category (such as 90 days) has a zero value, then it will not print the zero value. So instead of seeing a report which shows

30 0.00

60 10.00

90 0.00

I get a report which shows only

60 10.00

Does this make sense to you? Thank you for all your help.

G

[Robert Kidd]

OK so your sub summary report is sorting by age of invoice and where there are no records for say 90 days you don't get a 90 day line and value.

Unless you create dummy records for the "missing" invoice ages either in the current table or shipping the whole lot out into a "report" database and creating dummies there, the sub summary report probably isn't what you need ( at least with a sub summary by invoice age).

Could you create a relationship to extract the 30,60&90 day totals ? I suspect invoice age uses Status(CurrentDate) somewhere so you may have to set the invoice age into a number field to be able to index it.