Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the value of a SUMmed field?
Message
 
 
To
21/04/2004 13:22:24
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00896971
Message ID:
00896975
Views:
24
You'll have to create Report Variable for the sum and use it in both places.

>In the detail band of the repoprt designer I display records, each having a field namend 'nAccepted'
>
>In the summary band I display the Total of the 'nAccepted' field by selecting SUM in the "Calculations" option of the "Properties" window of the expression.
>
>I need to use the value of the SUM (in the Summary band) in another expression in the Summary band of the report. The other expression is: nPercentage = (nAnotherValue / the sum of nAccepted==>*SUMmed from the Detail band).
>
>Is this possible?
>
>Thanks in advance!
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform