>>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.
>
>Hi,
>Without data and report very difficult to say why/what your problem is.
>Regards,
>Koen

Right, but I don't have much info myself. I have an escalation from the client, our client service people checked the stored procedure results that is used for that report. It returned 1 row with sum_cost = 0. That's why this 1.91 value in the report is so strange. I've checked the report file (and the class that generated the report). The report uses a variable which is set to use nvl(sum_cost, 0) as expression with the initial value of 0 and SUM option. It doesn't explain this mystery.