Returning a zero from a query

[system]

Show it on a free standing cell instead of a column in the data block
DeskI:

=NumberOfRows("DP_name") 

WebI:

=NumberOfRows(DataProvider([universe_object]))

Please avoid cross-posting, there is another duplicate post here

120×120 10.4 KB

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)

.

---

haider (BOB member since 2005-07-18)