Conditional Feld Size & Total Page Count

[trenttc]

Group Footer text field can be populated with from 0-6 lines. I want to count the number of non-blank lines in Group Footer, so the total of Group Footer + Detail lines can be calculated before TotalPageCount is calculated.

The problem is that when the Group Footer lands near the bottom of the page, TotalPageCount has 'incorrectly' decided it won't all fit on one page. And because Report Footer is suppressed if PageNunber < TotalPageCount, another page is printed with nothing but Report Footer data.

 

[Charliy]

What determines the size of your group footer? Is it a string field with "can grow" checked?

 

[hilfy]

What are you trying to accomplish by suppressing the report footer using this formula? There may be a better way to do it that doesn't use TotalPageCount (which can significantly slow down a report).

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com