SSRS - Textbox not splitting correctly across 2 pages

[shobdy (Shawn Hobdy)]

Hello,

I am modifying the Quotform to add a row directly above the Header Comments row that only shows for one company.

It works great unless the combined length is slightly over the length of the page.
It then pushes everything from my new row down to the next page.

If the entire length of the New row plus everything below it is a lot longer than the page length, it splits correctly.

I have added the new row, added a rectangle in that, then added the textbox in the rectangle. I did that because I need the text to start about an inch from the left margin to line up correctly.

Anybody have any ideas?

[Jonathan]

I believe there are a few properties for the groups/rows for these. I think you need to set KeepTogether to false so that it doesn’t push everything.

[aseidel (Adam Seidel)]

I find if one text box is set to grow and even if it is just close enough to the text box below to be touching, they will both push to the next page. Sometimes its safer to add another row to that group or section and add the text box separately.

[shobdy (Shawn Hobdy)]

Hello,

I just made sure the textbox was set to Cangrow: false and resized it to show all contents. I also left a small space at the bottom. It still pushes to 2nd page when printing.

I then added an empty row below the row I added as a buffer, same thing. Still pushed to 2nd page.

I also made sure that the textbox KeepTogether was set to false. No help.

Any other ideas?

[JasonMcD (Jason McDermott)]

I think this has come up here before. (I recall being frustrated by this myself.) I don’t think the issue can be solved.

I’ll try to find the post.

No I guess this was something else I was thinking of. Maybe subreports? I thought there was some element that does this and can’t be fixed per Microsoft, no? A consultant modified our AR Invoice form and I thought he hit that wall, too.

Anyway, Tablixes can be tamed, but I don’t know about textboxes:

SSRS Tablix printing on second page for long tables

Check the Row Groups for the “KeepTogether” property. You’ll want this to be False so SSRS doesn’t try to make sure the whole group fits on one page.

This guy is pretty smart…

SSRS Trying to keep tablix together on 1 page

Hello, I am modifying the ‘Print Cycle Count Sheet’ to both compress it and to get it to quit splitting the tablix box between two pages. It is confusing to the employees when the information is at the bottom of a page and the part you fill in is on the top of the next page. [image] I have it compressed just fine but still can’t stop the splitting. I highlighted the tablix and changed the property ‘Keep Together’ to true, didn’t help. Does anyone know how to keep the tablix together?

Last edit and I’m done. I found it in my notes; it was a subreport. It was really odd; the rows, which were tall-ish, if there were about 11-20 then the subreport wouldn’t start till page 2, but 51+ worked perfectly (starts on page 1 and continues as expected). I didn’t agonize over finding the magic cutoff number and I imagine it would depend on the row height anyway.

I can’t find where anyone else on planet earth has encountered this. Supposedly it was all fixed by or after SSRS 2008, but I’m sure we have always been more modern than that…

And now I can’t duplicate it. Guess I am crazy.