Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Variable Issue
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00122126
Message ID:
00122181
Views:
20
>>This is a classic problem, with a classic solution: you just can´t do it with variables. You need to calculate, *before* you list anything, the grand total, so it will be available for calculating percentages.
>>
>>HTH!
>
>Thanks for the reply, Federico
>
>Sorry about the rookie type questions but if I calculate the percentage values before I run my report, how do I pass the values to my report before it runs.... with the 'with' command like I do in a procedure as in do 'something' with perc1,perc2,perc3 etc. ?
>
>thanks for your time !
>
>Don

Don, a "Cheezy" solution (quick but not elegant) is to calculate the total values you need into a separate cursor with 1 record. Or, in this case, just the final sum. Then in your report, you calculate your percentages using the group total/pre-calculated value. The cursor will be available just like the table/cursor you are using for report data.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform