2 Replies Latest reply: Oct 28, 2011 9:06 AM by James Bradley RSS

    Gauge Display Problem.

    Max Yucebas

      I have a query which may return no results as below:


      LOAD  Count(ProductID) as Critical  

      Resident Product

      WHERE          UnitsInStock <ReorderLevel


      I display the  Critical on a Gauge (Led) and when no result return from the query the Gauge dissaperas where I would like to show the number 0.


      Also I tried to show the result of Critical on a Listbox to check if it is null or not nothing came up,


      Briefly my question is; how can I show the result as 0 when there is no results?