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

    Gauge Display Problem.

      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?

       

      Thanks

       

      Max