This has to be a simple something that i'm missing. I have a report that is based on a query. I don't want to see null values or zeros in the query that feeds the report. But when i put in this criteria, no records meet it, and i get #Error# on the report. My customer wants to see Zeros, but i'm showing Zeros for every line item in the report, when that is the case, and i don't need to see that either. I know this may make no sense, and that's because i'm tired of thinking about it.
Basically: How can i show Zeros instead of #Errors# when there are no records to report?
Basically: How can i show Zeros instead of #Errors# when there are no records to report?