I have a report that does not have a detail secton. In the Group Footer I sum a customer's records to get a Customer Sales Total. The Total includes the sum of cust_sales + cust_refunds. If the total refunds for a customer are greater than 20% of the sales I put an '*' next to the Customer Sales Total Amount. The field for the asterics uses two report variables: sum_cust_sales and sum_cust_refunds to do the calculation. The two report variables are reset at the cust_num and sum the obvious fields. This works well.

What I can not get to work is to have the appropriate '** Refunds are greater than 20% of sales' text at the bottom of the page. There will be multiple customers per page and I only want to have the Refund message if the astericks are on the page.

I tried using a report variable m_refund_mess that has the properties "iif(sum_cust_refunds / sum_cust_sales) > .2,1,m_refund_mess))". I set m_refund_mess initially to 0 and reset at the end of page. Unfortunately the message prints in the footer even though the asterics is nowhere on the page.

It must have something to do with the fact of when m_refund_mess (which is a report varaible that resets at end of page) evaluates the sum_cust_refund and sum_cust_num (which sum a detail field, and reset for each cust_num).

This is a very simplified example to illustrate my problem.

Brenda