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

Columnar Report/Summary Always prints on next page

edited April 2003 in General
Greetings,

I am running RB6.03 & D5 (Enterprise). My report has 4 columns & a summary.

Regardless of how many records are displayed in the detail band/columns the
summary is always printed on the next page. I would like the summary to
print below the end of the column with the most records if there is room on
the page.

i.e

Col1 Col2 Col3 Col3
1 6
2 7
3
4
5
Summary

Regards

Steve Schoultz

Comments

  • edited April 2003
    Steve,

    Try placing a group around the column that breaks on a static invisible
    variable or lable. Then place your summary information in the group footer
    band.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2003
    Hi Nico,

    Thanks for the suggestion, but that is not quite what I am after.

    By putting the summary information into a group footer it prints in the
    column where the data ended. My summary is full width & does not relate to
    the positioning of the columns.

    So I get

    Col1 Col2 Col3 Col4
    1 6
    2 7
    3 Summary....................................
    4
    5

    What I am trying to get is for the summary to print underneath the column
    with the most data

    Col1 Col2 Col3 Col4
    1 6
    2 7
    3
    4
    5
    Summary...........................

    Preferably if there is less than a full page of data the data should be
    spaced across the columns rather than filling up the first column all the
    way to the bottom, but I dont want column flow from left to right! since the
    left to right does not work in RB6.03. This would then leave more space for
    the summary. I think I may be wanting too much here :-).

    Cheers

    Steve.

  • edited April 2003
    You'll have to move the draw commands to accomplish this. Here is an example
    I created for you. Enjoy:)
    http://www.digital-metaphors.com/tips/AlignSummaryToLongestColumn.zip

    Created with RB 7.02 and D6

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited May 2003
    Thanks Jim.

    Slight problem though, I am implementing the code in Rap & it doesn't have
    access to ppReport1.Footer.PrintPosRect.Top.

    Cheers

    Steve.

  • edited May 2003
    You'll have to create a RAP pass through function to access that property.
    Here is an example that does create pass through functions for this kind of
    operation:

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


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.