SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS report objects aligning


SSRS report objects aligning

Author
Message
VSSGeorge
VSSGeorge
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2153 Visits: 1578
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.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: General Forum Members
Points: 62159 Visits: 13297
What if you explicitly set the location properties?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
doug.brown
doug.brown
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1519 Visits: 14816
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
VSSGeorge
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2153 Visits: 1578
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
doug.brown
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1519 Visits: 14816
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
Amit Raut
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1227 Visits: 342
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
mister.magoo
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10561 Visits: 7891
Hey George,

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

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

MM


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




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • jazzgilbert
    jazzgilbert
    SSC Rookie
    SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

    Group: General Forum Members
    Points: 37 Visits: 24
    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
    Joie Andrew
    SSCertifiable
    SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

    Group: General Forum Members
    Points: 6399 Visits: 2032
    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
    jazzgilbert
    SSC Rookie
    SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

    Group: General Forum Members
    Points: 37 Visits: 24
    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
    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search