Report footer Visible(Y/N) based on form Check box

[zvgs]

I currently have a form where you select the date range for the report to be printed.

I want to add a check box to the date form, asking whether to make the footer visible or not. How can this be accomplished.

Or

I have totals for individuals grouped per month and a total in the footer for each individual for all months. If the date range for the report is only one month, your left with the footer total only duplicating the one month total. It's an eye sore if you only choose one month.

i.e. Dont' want the footer total here.
Name column1 column2
month1 12 24
total 12 24
vs. Wanting the footer total here.
Name column1 column2
month1 12 24
month2 02 10
total 14 34

 

[zvgs]

I have figure the code and On Format for footer based on check box option for making the footer visible.

The only thing now is that I'm still stuck with the footer total for months showing up when each employee only has a record for one month.

Is there a way to say if employee only has records for One month then do not show the total? when this occurs, all it is doing is duplicating the numbers.