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

Orientation

edited June 2004 in Subreports
I have this set-up, which I did after a suggestion by Nard (see 5 msg
up):

Layout
-------

Main report connected to Department.
DetailBand
Child Subreport1connected to People
SummaryBand
Section Subreport2


In the above the main report will print one detail band for each
department.
The childreport will print the people followed by the second child to
print the invoices.

Now the problem is that the the Departments report needs to be in
landscape and the People and Invoices need to be in portrait. How can
I do this? I read somewhere in this group about someone who had a
problem like this and was told to use Section instead of Child, but
will my report work when I change the People Child report to Section?



--
Thanks in advance,

Stijn Verrept.

Comments

  • edited June 2004
    Stijn Verrept wrote:


    Oops I mean 50 msg up. ("Empty page instead of report").

    --
    Kind regards,

    Stijn Verrept.
  • edited June 2004

    Only a section style subreport can print in a different orientation than the
    main report. A subreport set to to PrintBehavior of pbSection will be
    definition start and end on its own page space.

    If you need a report conisting of some pages with portrait and some pages
    with orientation then this indicates your are creating a document that is
    essentially multiple 'sections'. I think what you need is something like
    this:

    Main report connected to Department.
    DetailBand
    Section Subreport1 - no data connection - landscape
    Section Subreport2 - connected to People - portrait
    Section Subreport3 - connected to Invoices - portrait

    In the above, I am assuming that the Section1 is a one page report. A
    report/subreport that is not connected to any data, will print a single page
    and stop. Section 2 will list all people in the department. I am not sure
    whether you need Subreport3 to be another section that prints all Invoices
    for the department or perhaps you want it to be a Child that prints all
    invoices for a Person.


    --

    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2004
    Nard Moseley (Digital Metaphors) wrote:


    Thanks Nard for your reply. When I do it like you tell me will it
    print in the correct order?

    Because every department contains lots of people and the invoice has to
    be printed after the people page.

    The previous solution you gave me worked perfectly:

    --------------------------------------------------
    2. An alternative way to model this report might be as follows:

    Data
    ------
    Department
    People
    Invoices

    Main query result set that contains a list of departments. (You may
    have a department table you can use for this, otherwise perform a
    Select Distinct on the people table, but only select the department
    info.

    Second query result that contains a list of people - Link this query to
    Department query.

    Third query of Invoice data, linked to department.


    Layout
    -------

    Main report connected to Department.
    DetailBand
    Child Subreport1connected to People
    SummaryBand
    Section Subreport2


    In the above the main report will print one detail band for each
    Department.
    The childreport will print the people followed by the second child to
    print the invoices.
    --------------------------------------------------

    Will it work when I put a child subreport on the detailband of
    departments, connect is to nothing and then put the People subreport on
    this new subreport and make it a section subreport?

    So like this:

    Main report connected to Department.
    DetailBand
    Child Subreport1 connected to nothing
    Section Subreport 2 connected to People
    SummaryBand
    Section Subreport3




    --
    Kind regards,

    Stijn Verrept.
  • edited June 2004
    Found a solution :) Made a group footer and put the section subreports
    in there.

    --
    Kind regards,

    Stijn Verrept.
  • edited June 2004
    Great. :)

    --

    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com


This discussion has been closed.