Orientation

rbuser

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.

rbuser

Stijn Verrept wrote:


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

--
Kind regards,

Stijn Verrept.

nardmoseley

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

rbuser

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.

rbuser

Found a solution Made a group footer and put the section subreports
in there.

--
Kind regards,

Stijn Verrept.

digitalmetaphors

Great.

--

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