Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Headers and footers, printed alone

edited February 2006 in General
Hi;

i have a report with 3 groups bands and its detail, but some times due to
paper size, the group's headers or groups's footers are printed alone at the
end of the page (headers) or at the begining at the new page( footers),
while their detail is printed on another page.

How can i make the report to print group's headers/footers along with their
detail on the same page?

TIA

Comments

  • edited February 2006
    Hi,

    First try adjusting the NewPageThreshold property of the group. This is the
    "New Page When Less Than" option of the group dialog. If you are unable to
    get the results you need using this property, take a look at the following
    example on hiding an orphan group header...

    http://www.digital-metaphors.com/tips/HideOrphanGroupHeader.zip

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2006
    Group's NewPageThreshold, seems to work perfect for now, anyway ill check
    the example...

    i have another question, in the report i mentioned (3 groups), some times
    1st and 2nd and even 3rd group's total are exactly the same, if that's the
    case, i want to print only the last total, for example:

    Header group 1
    Header group 2
    Header group 3
    A
    A
    A
    Total Group 3 = 1000
    Total Group 2 = 1000

    Should be printed:

    Header group 1
    Header group 2
    Header group 3
    A
    A
    A

    Total Group 2 = 1000


    How can i do that?





  • edited February 2006
    Hi,

    Two options...

    1. Precalculate the group totals before the report is generated and set the
    visibility accordingly. This would be the easiest way to go about this.

    2. Place invisible LookAhead variable or DBCalc components inside the
    headers and compare them before the group footers print. These LookAhead
    components will calculate on the first pass of the report essentially making
    the report slower.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.