>>>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.

check the variable.