Visual Studio report creating multiple pages

Question

Post reply

Visual Studio report creating multiple pages

bzabel

Right there with Babe

Points: 734
More actions
September 16, 2010 at 10:04 am

#238398

I need some help with controlling how visual studio is breaking up my report into more than one page when all the content can easily fit onto a single page. Attached is a file with screen shots of the 2 pages it creates along with the very simple layout definition of the report...I have tried changing the body size, shrinking text size...etc, but for some reason it always breaks at the same point. There is no page grouping set up and I have not inserted any page breaks anywhere so I'm lost and about to put my fist through this computer screen!! Help!

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Russel Loski SSCertifiable Points: 7054 More actions · Answer 1

Are the Report Properties page size and interactive size settings what you expect? Check the margins as well.

Russel Loski, MCSE Business Intelligence, Data Platform

bzabel Right there with Babe Points: 734 More actions · Answer 2

Where do you look to check the interactive property settings? I don't see this option anywhere in the options on the report tab.

Lowell SSC Guru Points: 323482 More actions · Answer 3

it looks to me like the report is designed to be bigger than the paper , isn't it? so it cannot fit untill you tweak it to a smaller width?

or do you mean it prints one line on a second page? it looks like there are 20 lines(two occupied by the header...18 lines of data)

is there a setting that is causing that?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bzabel Right there with Babe Points: 734 More actions · Answer 4

The page setup is actually set up to landscape Legal, so it shouldn't have a problem fitting. I can't find any setting that would limit it to 20 lines per page, and yes that is what is driving me nuts! It prints a second page for only one line when it can easily fit onto one page.

Chris Johnson-445534 SSC Veteran Points: 250 More actions · Answer 5

Did you try setting bottom the page bottom margin to zero in the Report Properties?

Chris

Thanks,

Chris

Newtek Web Hosting

bzabel Right there with Babe Points: 734 More actions · Answer 6

Yeah I tried that...no matter what the bottom and top margins are it doesn't change the result. That is unless I make the bottom margin something crazy like 5 inches and then it will print out 3 pages...the last page will still only have 1 page.

Dennissinned Ten Centuries Points: 1318 More actions · Answer 7

bzabel (9/16/2010)
Where do you look to check the interactive property settings? I don't see this option anywhere in the options on the report tab.

In your properties window - Select "Report" from the drop down menu. Interactive Size settings are under the Layout Heading.

Do you get the same results when you output the report to a pdf? Or is it just in the preview pane?

bzabel Right there with Babe Points: 734 More actions · Answer 8

I changed the interactive size to match the page size, but it was already set to 8.5 x 11. Changing it to match the page size of 14 x 8.5 didn't do anything...I still get the same result where the last line goes to a second page.

bzabel Right there with Babe Points: 734 More actions · Answer 9

Alright so I finally figured it out...I had the List box grouped by DOY, hence the last line which happend to be the roll over hor for production was going to the next page. Got to love spending countless hours on something so simple...a learning experience!!!