Portrait and Landscape in Same Report

[LarryDeLaruelle]

Is it possible to print both landscape and portrait within the same report?

I've tried setting it up as sub reports (one in portrait and one in landscape) but that did not work.

Any suggestions?

Larry De Laruelle
larry1de@yahoo.com

 

[MichaelRed]

As far as I understand Ms. Access, there is no "access" to the printer properties from within Ms. Access, so the brief, and disappointing answer is "NO!".

As to a suggestion, Simply generate the "sub reports" seperatly. This works MUCH better if the reports are instantiated via forms/code than to do it manually, but you can maintain some degree of consistency in the data and commanality in the appearance this way.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[LarryDeLaruelle]

Thanks Michael.

The customer would like to print a set of reports with mixed formatting -- some in portrait and some in landscape.

Sounds like that is a no-go for this project.

Back to the drawing board.

Larry De Laruelle
larry1de@yahoo.com

 

[MichaelRed]

The "Set" of reports should bne no problem. It is just necessary to set them up independently for formatting purposes.

I often set up systems like this, where I create a temp recordset for the coordinated reports. Then just do a loop with the report names. Can't get the pagenation to caryover w/o out a lot of extraneous effort, but everthing else can be from the common resord set(s), created JUST for the reporting procedure.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[LarryDeLaruelle]

Michael:

If I am following you, I would set up each report independently and then write some code to open/print each sequentially?

How would that work with grouping? The goal, based on the client specs is to have mixed portrait and landscape within each grouped section.

Thanks again.

Larry De Laruelle
larry1de@yahoo.com

 

[MichaelRed]

Larry,

Sorry for the delay in response.

I think you are trying to go further with the 'mix-and-match' approach to the flipping than I ever have.

To do the change within the groups, you would need to make a report for each variation in the layout, then arrange the RecordSource for the report to be varied by the grouping.

I have usually approached this by:
A.[tab]Generating the reports
B.[tab]Assigning their RecordSources to a parameter query
C.[tab]Within a CODE module, Get the list of the GroupBy objects
D.[tab]Use a loop to set the parameter(s) for the query
E.[tab]instantiate the reports (DoCmd.OpenReport ...)

This technique is rather simplistic, however it is also fairly easy to implement and quite flexible. You may have any number of Reports and even have different selection criteria (e.g. parameter queries and parameters) for each.

The downside is that it is rather labor intensive - especially from the maintenance perspective.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over