Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report shows value when it should not
Message
 
 
To
02/12/2015 17:44:26
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01628178
Message ID:
01628339
Views:
40
>>>>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.
>>
>>What do you mean?
>
>put code to log the variable value into a file and get it.

You're still clear as mud. How do you record a variable in a report? Besides, I'd rather not change the application at all - any ideas of keeping the existing code and identifying the problem?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform