SSRS report objects aligning

Question

Post reply

SSRS report objects aligning

VSSGeorge

SSCrazy Eights

Points: 8146
More actions
January 28, 2014 at 9:43 pm

#303514

Hi
I have a SSRS reporting requirement where a table is required to be shown on report header part for displaying a study code in the report.
As table object cannot be included in report header part, I have used 4 textboxes in the header part to fulfill the requirement. In the design view of SSRS report, both these objects are getting aligned. But when it comes to the preview of the report and in the report export forms, it is not aligning as seen in the Design view of the report.
I have done all possible ways to get these objects aligned. But still I cannot accomplish that. Please suggest some ways to do that.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

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

What if you explicitly set the location properties?

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

doug.brown SSCertifiable Points: 5607 More actions · Answer 2

I have sometimes been able to force report elements to align by putting them in a rectangle. Might that work for you here?

Doug

VSSGeorge SSCrazy Eights Points: 8146 More actions · Answer 3

Hi Doug

Can you explain a bit on how you did it.

I have tried adding all the report textboxes in the report header into a rectangle and align it with the report elements in the report body. Still in the preview, it is coming not aligned.

doug.brown SSCertifiable Points: 5607 More actions · Answer 4

When I have used rectangles it has usually been in the report body rather than the header. I place the rectangle, and then position my textboxes in the rectangle where I want them to be lined up. Once my objects are in place I shrink the rectangle so it is snug against the textboxes on the left and right sides (if I didn't already place them in the rectangle that way).

I'm not sure if I have tried this in the header, though - perhaps it behaves differently there? I would hope that isn't the case.

Doug

Amit Raut SSCrazy Points: 2613 More actions · Answer 5

Try setting properties related to the textboxes, like "can increase to accomodate contents" to false.

You may try the alignment by setting hard coded values to the textboxes. Just to see if length of data is causing the misalignment. I tried replicating the scenario, but alignment in header section worked for me as such (I'm using SSRS 2005).

mister.magoo SSC-Forever Points: 47068 More actions · Answer 6

Hey George,

Any chance you could attach a sample report that demonstrates what you are trying to achieve?

See the link in my signature[/url] if you are not sure how to do that with embedded sample data.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

jazzgilbert SSC Veteran Points: 221 More actions · Answer 7

Rectangle solved a similar issue for me, thanks for your post. I'd used rectangles in the past, but guess I needed the reminder. 🙂 I was searching based on the idea that there must be some layout options like in Word, when you paste an image - like inline, floating, etc. Still seems like there ought to be something like that in SSRS, but rectangles are working for my current report.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 8

I also agree with the use of rectangles. They are an organization tool and are meant for this purpose.

The only thing I have to watch out for with rectangles is making sure that what you want inside the rectangle is actually in there. Note the name of the rectangle object. Then after placing your textboxes inside the rectangle select each textbox one-by-one and look at the object properties. There is a property called "parent". If the textbox is inside the rectangle the value of parent will be the object name of the rectangle. Sometimes it can take some trial and error to ensure your objects are inside the rectangle.

Joie Andrew
"Since 1982"

jazzgilbert SSC Veteran Points: 221 More actions · Answer 9

One thing I've still not sorted is how to manage tables in Word. The main reports I generate I export to Word, where I do a little final tweaking before saving them to PDF for customer consumption. I suppose the real solution is to get them to a point where they don't need any tweaking, which would be fantastic, but meanwhile I get lost in Word hell trying to manipulate tables so the &$*(^ will print properly. :crying:

c00185918 Grasshopper Points: 11 More actions · Answer 10

Format tab has many options for alignment including horizontal and vertical spacing, make objects the same size, center in form or align in a certain direction.