report with landscape AND portrait?

[shelron]

Access xp report

Is there a way to set the detail section as landscape, and the group header section as portrait?

Or is it all one or the other?

I am trying to combine a portrait formatted letter (correspondence) and a couple of sub reports that need to be formatted as landscape.


thanks, ron

 

[randysmid]

Hi,
Is it possible to create two separate reports, then print as though it were one? You can do this in code. For instance, let's say you have a command button labelled "Print Report". The clicked event for this button can call 1 or more reports, and make it appear as though only one report was run. Here is what the code might look like, using "filter" to send the necessary criteria to the report:

dim strFilter as String
' assume the user selected a specific state from
' a listbox (called lstState)
strFilter = "[fldState] = '" & Me!lstState & "'"
' now print the report that is in portrait mode
DoCmd.OpenReport "rptCustomerPortrait", & _ acViewNormal, , strFilter
' (acViewNormal sends the report directly to
' printer without any sort of preview)
' NOTE - use acviewpreview if the user needs to
' preview before printing
' now print the report that is landscape
DoCmd.OpenReport "rptCustomerLandscape", & _ acViewNormal, , strFilter


HTH,
Randy Smith
California Teachers Association

 

[shelron]

No. it's not possible.

I am doing a large run, about 600 groups which have many subs, or detail sheets.

The objective is to have them all grouped so that the first page will indicate to the assembler a break, hence a new envelope.

But thanks for your help.