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.
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 |
 |
|
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? |
 |
|
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. |
 |
|
|
|
|