This is how the SSRS is setup in microsoft report builder:
When run as a PDF, the formatting is perfect as below:
But when run as excel, the formatting gets changed as below:
Is there a way to make excel bring that middle section aligned with the other two columns without changing any of the other formatting?
When I have run into this issue in the past, it was because the textboxes were slightly misaligned, even if only by a pixel. I would suggest checking that the textboxes in each column are the same sizes and at the same heights.
As far as I am seeing, all of the textboxes are the same size and height
I was just going to make the same comment at Ross. What I do to troubleshoot is set box borders or background colors. That helps visually see what’s going on.
Edit: Also check the alignment of the text boxes to ensure there aligned.
PackSlip.rdl (213.7 KB)
I believe all of the alignment is correct. But I could be looking at something totally different, therefore I am attaching the rdl file if you could take a minute to verify as well
I’ve got a pile of stuff I need to finish up before a afternoon meeting but I’ll try to get time to give it a look.
No rush, appreciate the help
I really like that Font for things like Packing Slips, got to file that one away in the good ideas list.
Maybe try making sure all of the elements are set to ‘Cannot Grow’.
Very low expectation of this being a solution, but sometimes to make sure elements stay put, placing an empty rectangle to sort of confine the space has worked for me.
How would I make all of the elements set that way? Just add a rectangle around the entire row?
If you have text boxes that need to stay aligned horizontally, put them inside rectangles. Otherwise SSRS will always do this to you.
I pretty much never put a text box directly on a report - ALWAYS add the rectangles first.
I’ll attempt to explain, but it’s not likely that this is the issue. I would be looking at the ‘CanGrow’ option and the sizing like others were pointing out. But you might use this trick in the future.
It is more related to when you have text boxes that you are trying to prevent SSRS from shifting around to reclaim unused space. You don’t put the rectangle around the row, rather you would place an empty rectangle ‘close by’ in order to give the renderer something to ‘pin’ against. Let me see if I can find the example where I was using it…
This is a very important point if the textboxes are not inside rectangles that may also cause the issue you are seeing @ygpatel. If you haven’t found a solution in a few hours I may be able to look at the rdl as well.
If you can provide an example that would be helpful
The report has 3 tablixs 4,5 and 6 for each column. If you look at Tablix 4 it has two blank columns at the end which is probably causing Tablix 5 to shift down.
Please review
Also, as others have mentioned, rectangles should be used for placing objects, makes modifying reports and moving objects easier.
That was the issue! I never realized the blank columns, thanks for taking a look and catching that
