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

Second page not aligned correctly

edited September 2001 in General
I have a report fed by several pipelines. Master, detail, and detail to
detail. I have laid out the report using PageStyle for the basic form
layout and subdetail bands for the required sub reports.

One each page I have detail band which is to print twice. I have set the
PrintCount to 2 for the detail band. For each of the two detail bands I
have another nested sub-detail band which can print from 1 to 5 records.
PrintCount here set to 5.

If I set the detail band to Static things can align properly, but only one
sub-detail record is output. If I set the detail band to Dynamic, all of the
sub-details will print, but the spacing is screwed up. The issue is that
page allows for upto 5 of the sub-detail records and the output must match
the form layout. This is why I used the PageStyle band. The second detail
record must start at the same point on the page but the position is varied
by the number of sub-detail records allocated to the preceeding detail
record.

Any suggestions on resolving this?

thanks
mark

Comments

  • edited October 2001
    Use the detail band instead of the pagestyle band. The pagestyle is best
    used to print as a background behind all of the other bands.

    Subreports have a PrintBehavior property. Set this to pbFixed. The
    subreport will not stretch and will only print in int the space that it has
    been given in the band. This should be what you're looking for.

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited October 2001
    Thanks Jim for your response, however it is not fixing the issue

    I use the PageStyle as a background which provides the lines and literal
    data for the form. In fact you had suggested this earlier.

    To better explain things I have three tables Main, Vehicle, and People.
    One main record, 1 to many vehicles, and 1 to many people in each vehicle.

    In the Detail band of Main I have a vehicle sub-report, which has in it a
    people sub-report. Each page will list two vehicles and the position of the
    print position of this is fixed. If the number of people varies then the
    position of whre the second vehicle record is printed varies.

    I tried setting the people report to pbFixed as suggested, when doing this
    only one person record is printed even if more exist for a given vehicle.
    using pbChild prints all of the records as desired, but then I have the
    spacing problem.

    Any additional help would be appreciated.

    Thanks
    Mark


  • edited October 2001
    I think that you want the People subreport as pbFixed, but stretch its
    design time height to be able to accomodate the 5 people maximum. You can
    reisze the subreport component as it appears in the parent band to do this.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited October 2001
    "Jim Bennett (Digital Metaphors)" wrote in
This discussion has been closed.