Skip to Content
avatar image
Former Member

New Page after Group Footer, loose the last blank page

I'm basically uing the Grouping section as my report with each group being like a mini report within the overall report run.

I've got the Header in the Group Header section and the Footer in the group footer section. I set the Group footer to New Page After which works great except on the last group footer where there's no more groups, it prints a blank page. It there is only one group then it always prints the extra page which is blank. In the last group footer section I have the New Page After and also the Suppress Blank Section but it still prints out the blank page. Is there a formula to use such that if the last page will be blank it will not print it? I'm sure this question has been asked a zillion times but I could not find the answer searching the forums.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 13, 2010 at 06:23 PM

    Hi Harry,

    Instead of checking the new page after in the group footer, i suggest you use the following formula.

    NOT OnLastRecord

    This will produce a new page after every group footer unless the report is processing the last record which should be true after printing the final group footer.

    Marshall

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sorry Harry, I am trying not to be obnoxious or a smarta$$ but all the functions are documented in the help file and if the help file is too cryptic you can always search on here for articles. There is a bunch of information on SDN (most of it written before SAP took over) that I have found useful in the past.

      What I found really useful when I was learning Crystal was looking at the available functions in the function tree that is found in the formula editor (if you don't see it press ALT-U to turn it on or off). You get a different list of functions depending on where you are when you invoke the formula editor and what the formula is expected to return.

      The formula tree catergorizes all the functions which should give you a clue on how the function is intended to be used and when used in conjunction with the help file you should be able to figure out what you need.

      Just my two cents.

      Marshall