General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only