>>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.
If it's not broken, fix it until it is.
My Blog