Hello,
i’m running some queries for a report, and counting the records retrieved from the queries. For some of the queries, i’m expecting zero records; whenever i refresh data i get the message that “No records retrieved for xxx” and then when i want to show the count on a report, the cell is empty. I want to avoid this message and show zero (instead of empty). Can anyone help me with this? Thanks.
monty_mm (BOB member since 2007-11-22)
This issue is discussed a lot in the past, check the Reporter FAQ’s section to avoid this message.
If the cell is showing blank, Go to Format cell and check what is the setting for NULL values… , If required change it to 0 and check.
BO_Chief 
(BOB member since 2004-06-06)
Take a look at this section in FAQ
To show zero instead of empty follow cheif’s suggestion.
KhoushikTTT (BOB member since 2005-02-24)
The duplicated post is here:
Please do not cross-post. It leads to fragmented discussions and is against our forum rules.
Topic locked.
Marek Chladny 
(BOB member since 2003-11-27)