Got it.

Created a variable called "lines" Calculate option set to sum.

then added _vfp.setvar("lines",lines+1) to the on exit footer expression.

got the answer from: The Visual FoxPro Report Writer: Pushing It to the Limit and Beyond
By Cathy Pountney

Thanks guys