Haven’t had any luck finding more detailed instructions on being able use variables from a sub report in calculations back on the main report. I know you have to be able to do this and I can do it easily in Crystal reports. There are a few lines ive found in the help about using the subreport name in variable name to retrieve it but hasnt worked. If anyone has some samples to show that would be great, thank you!
+3Mike,
What I found was that I had to convert the variable to a number using the CDec Function.
Here is an example, from a live system, were the $subReport_PayTotal is passed from the subreport
We multiply by -1 if the type is a credit memo.
=IIF ( [SOOrder.OrderType]<>'CM',( CDec([SOOrder.CuryOrderTotal]) - CDec($subReport1_PayTotal) ), (CDec([SOOrder.CuryOrderTotal]) - CDec($subReport1_PayTotal)) * -1)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
