General information
Category:
Reports & Report designer
Hi Nadya,
I've been using CalcRpt as the horizontal sum or each row in the Detail band and also in the Summary band as the vertical sum of the total of that result.
Each row record pertains to an employee and their individual total is calculated in the Detail band and at the end of the report their combined totals are calculated in the Summary band. Would that change what the expression should be?
Thank you!
Max
> Max,
> If this case nCalRpt program even should not be called, since we're not using it anymore.
> Ok, once again:
> 1) Create a variable in Report. Give it another name, say, MyVal
2) Put field1+field2+field3 in the value to store and 0 in Initial value
3) use this variable in detail band in field expression:
iif(myVal+Field2>0,(MyVal/myVal+Field2)*100,0)
> See, if the above will work. If not, try first on a test report, then see, why it is not working on yours?
Previous
Next
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