• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

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?
 
0
dbaSQL
Asked:
dbaSQL
1 Solution
 
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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now