>>>Hi everybody,
>>>
>>>This is a very perplexing issue. There is a report that shows 0 for the qty on hand but it does show inventory value. The stored procedure that is used to generate report data returns 0 for the sum_cost value.
>>>
>>>In the report there are many report variables. The report variables used to show inventory value use NVL(sum_cost, 0) as an expression and correct level for the grouping. Yet it shows the value (see attached picture).
>>>
>>>So, it doesn't make sense and I'm not sure how to figure this problem out for the compiled application (and the report built in).
>>>
>>>Any ideas why would report variables show wrong value?
>>>
>>>Thanks in advance.
>>
>>Maybe you've got a null value and are not catering for it? And maybe set nulldisplay is 0?
>
>In the expression I use NVL(sum_cost, 0). And besides, the stored procedure returns 0 for sum_cost. That's why I can not understand where this number is coming from.
I am confused by your statement. You said the value for the inventory value shows and the report variable to show this figure is NVL(sum_cost, 0). But the one showing 0 is the qty on hand, so I understood that the qty on hand must use another variable or field and that is what I thought must have a NULL value in. Maybe you can try to explain the problem better, please?