Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Report Header question

Author  Topic 

juno
Starting Member

11 Posts

Posted - 2003-09-24 : 17:31:17
I would like to set my report in such why that all the pages will include the Header. Is that possible?

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-09-24 : 18:20:43
put stuff in the Page Header section, not the report header.

- Jeff
Go to Top of Page

juno
Starting Member

11 Posts

Posted - 2003-09-26 : 18:07:44
Sorry Jsmith8858, I wasn’t descriptive enough.

What I am trying to do is the dictate the number of record that appear on my report. At this time I have all of them. I would like to be able to set say 5 record per page or maybe 7. Whichever the case is that possible?
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-09-26 : 19:48:15
You can always resize the detail section so that only 5 of them will fit on a page.

The other option is to add VB code to the Detail section of your report. I can't remember the exact event name, but it's probably something like OnFormat or OnPrint. You can create a counter that forces a new page after 5 or 7 beats. This is really not a great way to do it, unless you're really good with VB, and even then it will slow down the report's execution.
Go to Top of Page
   

- Advertisement -