Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing out charts on seperate pages 1

Status
Not open for further replies.

irethedo

Technical User
Feb 8, 2005
429
US
I have a report with several charts and I am trying to figure out how to print out each of the charts on its own page.

I have tried to squeeze all of these charts into the report in the report footer section but they do not fit and end up looking squished if I resize them smaller.

I also would like to have the page header and page footer sections of the report shown on each page.

How can I set this up?

Thanks
 
The charts should be in the detail section. Have you tried putting the Page Break object in there, between the charts?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
 
Thaks you Ginger...

I found that the details section will only allow 21 inches and I need a little more than that for my charts (they take up 7 pages...)

Is ther eany way to squeeze two more carts in this section without squishing the charts so they are heard to read?
 
You can create multiple "detail" sections by setting your final sorting and grouping expression to your primary key of the main report's record source. If your report doesn't have a record source, just add a new sorting and grouping level on a constant like:
=1
View the Header and Footer sections for this level and move in some charts.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top