Sql – Prevent a large textbox from getting put on the second page in SSRS

formattingreporting-servicessql server

Greetings.

I've got a large textbox in SSRS, with a few textboxes under it. When I view the report in Preview mode, or from the Report Manager it looks fine. But when I actually render it from code (into a PDF), it puts my large textbox on the second page (and leaves what's below on the first page).

There's a Connect request here:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=238240

that details the problem, but it shows no workarounds. Any ideas?

Best Answer

the reason behind it breaking to the next page is probably because it's too long to fit on a page. rs defaults a page to have 1 inch margins, so if you want it to print on a single page your report contents shouldn't be wider than 6 1/2 inches (8.5 inches minus 1 in for both sides).

you should be able to make the textbox have a smaller width and just give it a bigger height and it should print on one page. also, changing the margins to 1/2in will help.

Related Topic