Reporting Services - page break

hi.  i put a report together (sql/rs v2000, vs. net 2003), everything works great, but the report is coming with a page break line in it.  like this:

.......
............
................
Oct 25 9:57 AM GEH0 B 5 9,483.00
Oct 25 9:57 AM GEH1 B 5 9,472.00
Oct 25 9:57 AM GEH7 B 5 9,465.00
Oct 25 9:57 AM GEH8 B 5 9,499.00
--------------------------------------------------------------------------------
Oct 25 9:57 AM GEH9 B 5 9,492.50
Oct 25 9:57 AM GEM0 B 5 9,480.00
Oct 25 9:57 AM GEM1 B 5 9,469.50
................
..........
.......

all the data is correct above and below the line.  but, i want to get rid of that line.  
any thoughts?
 
LVL 18
dbaSQLAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dnsvhCommented:
Where are you putting these data? A table? A list? A matrix?
0
dbaSQLAuthor Commented:
sorry, i should have said that.  that page break is in the email that i'm sending via the subscription.  everything is fine...it just has that line in the middle of the report
0
chrismcCommented:
Do you have a line like that anywhere in the report definition?
Or do you think it is the email process putting it in?

Cheers
Chris
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

dbaSQLAuthor Commented:
i have a line in the header, intentionally, but no lines in the body....except for this one
0
DavidGreenfieldCommented:
Extend the page height property and this will move the page break down.  To do this Right click off the main body and click properties, then go the layout tab and extend the page height, that will move the page break further down.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dbaSQLAuthor Commented:
i moved page height from 11" to 15"  
still no good, i've got 2 page breaks in there
0
dbaSQLAuthor Commented:
changed it to 20", got rid of one of the page breaks.  i will try it again and let you know
0
dbaSQLAuthor Commented:
ok, changed it to 30", the page break(s) gone
who'd a thought.....excellent.  
thanks much, mr. greenfield
0
DavidGreenfieldCommented:
No problem glad to help

David
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.