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