>>I have a report with a footnote that should only print when one or more detail lines passes a test. I have been playing with setting report variables in the detail's on entry and on exit run statements, and setting the print when for the field, but can't seem to get it to work.
>>How should I go about this?
>
>Set up a variable FOOTNOTE with IIF(any condition met, 1, 0), and set it to calculate its sum and to reset itself on a group end.
>
>In the PRINT WHEN of the footnote, specify FOOTNOTE>0.
>
>HTH!
My original solution was very similar to this, but for some reason, when running a calculation from the detail line, the output was getting an extra line in it (this report must be printed to ASCII -GRRRRRR...). I have resorted to setting a global variable before the report is run, and checking it in the field's print when. Thanks for your reply.
Erik Moore
Clientelligence