Unknown variable or datafield on a IIF statement
Hi.
I have a IIF statement to generate a status field on my fastreport page.
Status: [(IIF(<frxDBDatasetTemp."paga_liqu"> - SUM(<frxDBDatasetBapa."bapa_liqu">,DetailData1,)>100,'true','false'))]
On execution it acuses Unknown variable on the field frxDBDatasetTemp."paga_liqu".
The problem is that I can show the value of this field with no problem. The problem seems to happen only when I try to calculate or compare the value of the field.
Thank you for your time. Cheers.
I have a IIF statement to generate a status field on my fastreport page.
Status: [(IIF(<frxDBDatasetTemp."paga_liqu"> - SUM(<frxDBDatasetBapa."bapa_liqu">,DetailData1,)>100,'true','false'))]
On execution it acuses Unknown variable on the field frxDBDatasetTemp."paga_liqu".
The problem is that I can show the value of this field with no problem. The problem seems to happen only when I try to calculate or compare the value of the field.
Thank you for your time. Cheers.
Comments
did you just type it in the memo view?
I assume you have the memo in the correct footer
Could it be inside the wrong footer even if I can print its value with no problem?
The problem only happens when I try to make calculations on it.
the IIF function is for use in a memo and the sumfunction is for use in amemo
in a footer
IIF((value - sum) >100,'true', 'false')
The calculation is inside the if statement. I've tried this before and it seems to work great for other type of data.