A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Page Break



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2004, 05:53 PM
Michael H
external usenet poster
 
Posts: n/a
Default Report Page Break

I have built a Students/Classes database and I need a
report that will print out transcripts.

The report is set up fine, however, I need to have the
report print a different student on each page. Right now,
the report prints the student records on top of each
other.

Thanks in Advance
  #2  
Old April 30th, 2004, 06:17 PM
Dan
external usenet poster
 
Posts: n/a
Default Report Page Break

Good Afternoon!

Depending on how your report is set up, you can use
the "Force New Page" property to make this happen. This
property should be available in the Detail Section and any
Group Header/Footer sections you have set up. Setting this
property to "After Section" will usually work, but again
this can depend on how the Sections in the report are set
up. You can experiment with the settings to see how they
change the page breaks. hope this helps!

Dan

-----Original Message-----
I have built a Students/Classes database and I need a
report that will print out transcripts.

The report is set up fine, however, I need to have the
report print a different student on each page. Right now,
the report prints the student records on top of each
other.

Thanks in Advance
.

  #3  
Old April 30th, 2004, 06:30 PM
fredg
external usenet poster
 
Posts: n/a
Default Report Page Break

On Fri, 30 Apr 2004 09:53:32 -0700, Michael H wrote:

I have built a Students/Classes database and I need a
report that will print out transcripts.

The report is set up fine, however, I need to have the
report print a different student on each page. Right now,
the report prints the student records on top of each
other.

Thanks in Advance


In report design view, click on View + Sorting and Grouping.
Enter the StudentID field in the top panel.
Choose Header Yes in the bottom panel.
Save the change.

Click on the Group Header and set it's ForceNewPage property to Before
Section.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.