Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I need totals for each.....
Message
From
28/04/2008 20:04:47
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01312769
Message ID:
01313690
Views:
8
>>I am not sure what you mean by precision the field for quantity is a character and the length is 10 characters if this is not the proper answer please tell me.
>>
>>Thanks again
>>
>>Fred W.
>
>Fred,
>
>If this is a character field (hmmm, quantity? :) then how would you suggest to sum it?
>
>I believe in your case you would need to use report variable and use Val(quantity) instead for calculations (assuming all of the fields are actually numbers just represented as a character field).
>
>Or may be you can create a cursor with the numeric field (using CAST function) for the reporting purposes (if you're already using some cursor)?

He can also just use VAL(quantity) as the expression for the field in the report, it will sum OK. No need for a report var.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform