Report cut off in print preview (1 Viewer)

[swee]

I have a report based on a form and when I view the report in print preview, part of it has been truncated. I have attached a screenshot of it. Is there a better way for me to print the form other than as a report? If not, how do I show the entire report without leaving out any part of it?

Thanks a lot

 

[yippie_ky_yay]

Have you tried File - Page Setup... - Page (the tab) - and then selecting Landscape?

If you really want to keep it in portrait, you're going to have to change your subreport. Open it, and keep working with it until it looks right in print preview (and try to leave some extra room). Then when you go back to your main report it should fit.

Hope that helps!

-Sean

 

[swee]

Thanks all for the valuable replies and feedback. I changed the size of my subform and it looks better now. Now I have encountered another question, how to display just one record for each page of the report?

 

[mdemarte]

In the report, add the field with which you want to break in the Sorting and Grouping section. Make sure to check that you want a Group Footer. Now click on the Group Footer for that field, and change the Format to Force New Page After Section. Note: You don't have to have anything in the Group Footer, you just need it listed there.

 

[swee]

Thanks mdemarte. But I came across another way to achieve that. Under the properties of the Detail Section of the report, I selected Before Section for the Force New Page option. It works fine too. Thanks all again!