Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Network:
Windows 2003 Server
>>>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.
Stil, I would contact the client and get the data and investigate if this is reproducable.
I have a strong feeling it is a case of carbage in - out
Regards.
Koen
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement