We help IT Professionals succeed at work.

Reporting Services - page break

dbaSQL
dbaSQL asked
on
Medium Priority
767 Views
Last Modified: 2008-01-09
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?
 
Comment
Watch Question

Commented:
Where are you putting these data? A table? A list? A matrix?

Author

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
Chris McGuiganBI & Database Architect & Developer, Sitecore Developer
CERTIFIED EXPERT

Commented:
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

Author

Commented:
i have a line in the header, intentionally, but no lines in the body....except for this one
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
i moved page height from 11" to 15"  
still no good, i've got 2 page breaks in there

Author

Commented:
changed it to 20", got rid of one of the page breaks.  i will try it again and let you know

Author

Commented:
ok, changed it to 30", the page break(s) gone
who'd a thought.....excellent.  
thanks much, mr. greenfield
No problem glad to help

David
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.