I managed to use the below and have the blank lines at the end.

 

I managed to get rid of the extra pages from apearig within the report as well the blanks lines appear at the end.

I used the below two.

Under section expert formula for Suppress (No Drill-Down)

not onlastrecord

Under section expert formula for Print at Bottom of Page
Pagenumber = Totalpagecount

But now, when the blank lines continue to the next page, and if I enter 50 I am not having enough space to enter more text. I can only enter 40 lines.

Why is this?


Also I was trying to suppress the column header section in the last pages where the blank lines are generated, but there already exists a formula and I am not sure how to include the formula to suppress

I want to include the formula to suppress column headers  in the below existing suppress formula.


IF {Detail.ShowNAV} = "Y" AND

IF {Detail.ShowNAV} = "Y" THEN
    formula = true
ELSE
    formula = false

END IF

How can I additionally include the conditional formula to the above to suppress the column headers in the last page where the blank lines are generated?

 

I assume I can use something like onlastrecord? But I need to include this formula to the existing conditional suppress.

 

Any ideas?

in the section expert make sure the details section is set to kepe togther as false

 

I have tested a version of your formula

placing it on a report footer and had no trouble with it expanding over 2 pages when i made it 50 rows.

Your column header suppression question is not making sense to me either. Do you have groups with headers on a group feader level? Are these on a page header? YOu say you have 2 detail rows per page. How are you breaking this with only 2 rows per page? Do you need to suppress the header when both rows have shownav="Y" or either row or some other option?