How to display 0 in one row when there is no data in query

[system]

What Hyder said is the only way at the report level, though you have someother alternatives that were discussed here:

120×120 10.4 KB

How can I supress the ‘No Data To Fetch’ message? There are multiple methods of supressing the ‘No Data To Fetch’ message. Programmatically… If you copy this code into the ThisDocument module, it should work. To implement the code, you will need to have your Report which gives you the No Data to fetch message open. Click on Alt + F11, and the Visual Basic Editor will open. On the left hand side you should see a list of all the documents you have open. Under the name of the documen…

---

Jansi (BOB member since 2008-05-12)