From textboxes that disappear and move... Report layout problems

Question

From textboxes that disappear and move... Report layout problems

NoDBA

Right there with Babe

Points: 720
More actions
August 27, 2014 at 1:03 am

#292624

Hello folks.
I designed a report that is used for invoice printing. That means I want every page to have the same look, but different data to show.
I used mostly textboxes to display information, but for one table that shows dues, quantity etc. And I have a picture in the footer
After rendering the first page looks exactly to my requirements. But everything after the first page is kind of broken:
- several textboxes just disappear
- those boxes that do not disappear slide down... with every page a bit more
I tried several properties and configurations, but probably not the right combination. Or I overlooked something, actually I am sure I overlooked something.
Anybody encountered that kind of problem or knows a solution to it?
Thanks in advance

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

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Do some of those text boxes overlap?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

NoDBA Right there with Babe Points: 720 More actions · Answer 2

Yes. there were some overlapping textboxes. After I read your post, I changed that. However there are like 14 textboxes inside a rectangle which might still overlap at some points. I'll have to check and will come back to you in a few minutes. Didn't know that could cause such problems.

Thanks

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

NoDBA (8/27/2014)
Yes. there were some overlapping textboxes. After I read your post, I changed that. However there are like 14 textboxes inside a rectangle which might still overlap at some points. I'll have to check and will come back to you in a few minutes. Didn't know that could cause such problems.
Thanks

SSRS hates overlapping items.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

NoDBA Right there with Babe Points: 720 More actions · Answer 4

SSRS hates overlapping items.

Useful fact to know for the future.

There are now no more overlapping boxes. While I was at it I changed the font size, so it shows the whole text in every box. But I still have the same issues.

I might have changed too much properties while trying to fix my issues before posting, but I don't know for sure. It's just a guess...

EDIT: I should add that I have drawn a list tablix over the textboxes in order to allow for grouping.

NoDBA Right there with Babe Points: 720 More actions · Answer 5

I seem to have dealt with the part where my layout slides down with each new page after rendering the report. However, when I deployed the report to the Report Server, I noticed a dozen or so warnings informing me the aforementioned list tablix overlaps with several textboxes. These are the textboxes that keep disappearing.

Like I said, I use the list tablix in order to group the textboxes with the invoice number, so that there is only one invoice per page. Now that seems to be the problem why the textboxes are disappearing in the first place.

I thought that was a good-working way to apply grouping on textboxes. Is there a way to use that technique without disappearing textboxes?

I thought solution was at hand, but now I'm not so sure anymore...

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Personally I have not dealt with grouping in SSRS that much.

Could it be an option to use tablixes instead of text boxes?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

NoDBA Right there with Babe Points: 720 More actions · Answer 7

Koen Verbeeck (8/27/2014)
Personally I have not dealt with grouping in SSRS that much.
Could it be an option to use tablixes instead of text boxes?

I thought about that as well, but I'm not sure. The layout requires most information to be at an exact given spot. That seems quite hard to achive with tablixes, at least to me. But for now I'll try to do that anyway since I'm out of solutions.

Thank you for your efforts.

NoDBA Right there with Babe Points: 720 More actions · Answer 8

I solved nearly all my problems. Last thing I'd need help with, is an image that needs to be at the bottom of every page. Unfortunately, every way I can think of turns out to be the wrong way. Most of the time, it shows on the next page, which means I'd need two pages for every invoice. I tried it with a page footer as well, which lead to the same result. I'm stuck here.

For those who have the same problems I talked about in the first post:

I put a list tablix over the whole page and then used several tables (all grouped by invoice number) to create the layout I needed. It worked like a charm.