Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Percentage calculation in expression of report
Message
From
30/11/2001 14:06:10
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00588031
Message ID:
00588178
Views:
31
Max --

One of those "is it plugged in" questions.

Check the variables page just to confirm that the variable and it's expression is set up. I've pressed "Cancel" inadvertantly more than once!

Because the variable is dependant upon the report being completed (it sums each return value as the row is processed) the report field must be at the end of the report. You could also get that error if the report field is at the beginning of the report.

Jay

>Hi Nadya,
>I created the report variable named it nCalCrpt and put the "Value to store" as CalCrpt() and when the report is run it reads: "File nCalCrpt.prg does not exist"
>I placed the expression "iif(nCalCrpt+Field1+Field2>0, nCalCrpt/(nCalCrpt+Field1+Field2)*100,0)" as the 'Expression for Field on Report' but
>I wasn't sure if this was what I was supposed to do so then I created the nCalCrpt.prg with the expression above and named the field on the report nCalCrpt() and it gave the error "File nCalCrpt.prg does not exist."
>Thanks!
>Max
>
>> Where do you use your expression?
>> Create a Report varaible called nCalCrpt
>> Set it to be CalCrpt()
>> Release at the end of report (this, unfortunately, has some bug, but it's not relevant here)
>
>> Your expression now would be: (check for possible division by 0)
>iif(nCalCrpt+Field1+Field2>0, nCalCrpt/(nCalCrpt+Field1+Field2)*100,0)
Previous
Reply
Map
View

Click here to load this message in the networking platform