Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Expression
Message
From
25/04/2005 08:25:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
25/04/2005 04:21:03
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01007965
Message ID:
01008035
Views:
21
>Dear Experts
>
>In report field expression I use following line
>
>sum(flow_ra.lose)+ comm.sub2
>
>But it creates error e.g.
>File ‘sum.prg’ does not exists.
>
>I do not want to use CALCULATION beacuse as expression
>sum(flow_ra.lose)+ comm.sub2
>I want to get the sum of (flow_ra.lose) and amount of (comm.sub2)
>
>How to use sum() in field expression?
>
>Please help

You can sum flow_ra.lose separately. Create a report variable, that you might call total_loss (1), set it to your field (flow_ra.lose), and set the sum options. Then set your report field's expression to total_loss + comm.sub2.

HTH,

Hilmar.


(1) Note: "lose" is a verb; "loss" is the amount of money you lose.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform