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

Suppress Region according to page count

edited September 2004 in General
Hi,
I am using RB 7.04.
My report is divided into 4 columns (I have all my data in the detail
section). I also have a label that says "End of Report" in the summary
section because I want this label to print after all the details.

The problem is that when the details move to the second column, the label in
the summary automatically moves to the second page. How do I make my
columns shorter so that I can fit this label on the first page without using
a subreport?

Thanks,
Yelena

Comments

  • edited September 2004
    Hi Yelena,

    Unfortunately, this is how the summary band must work with columns according
    to the rules of the Report engine. Once a column fills up all the space it
    is given, the engine assumes that there is no space left on the page and
    moves the summary band to the next page. This occurs even if you limit the
    number of details per column as well. You will need to use the FooterBand
    to get the effect you are after.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2004
    I already have information printing out in my report footer section (date,
    time, and page number) so I want it to print out on every single page, but I
    don't want the "End of Report" label to print on every page, just the last
    page.

    I thought of suppresing the label according to the page count, so it would
    only print on the last page, but I'm not sure how to do this exactly. Can
    you give me specific instructions please?

    Thanks,
    Yelena



  • edited September 2004
    Hi Yelena,

    If you use a two pass report, you can check the Report.AbsolutePageCount and
    AbsolutePageNo to find the last page of the report and set a label visible.
    Here is the code I used in the FooterBand.BeforePrint event in RAP with a
    two pass report to get this effect.

    if Report.SecondPass then
    begin
    if (Report.AbsolutePageNo = Report.AbsolutePageCount) then
    Label1.Visible := True;
    end;

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2004
    That code worked, except I had to add an else statement to your code below:
    Label1.Visible := False;

    Thanks!
    Yelena


This discussion has been closed.