Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS report objects aligning Expand / Collapse
Author
Message
Posted Tuesday, January 28, 2014 9:43 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 627, Visits: 1,188
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.
Post #1535703
Posted Wednesday, January 29, 2014 12:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 14,433, Visits: 12,418
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1535728
Posted Wednesday, January 29, 2014 11:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:49 PM
Points: 205, Visits: 10,683
I have sometimes been able to force report elements to align by putting them in a rectangle. Might that work for you here?

Doug
Post #1536059
Posted Wednesday, January 29, 2014 11:25 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 627, Visits: 1,188
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.
Post #1536178
Posted Thursday, January 30, 2014 11:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:49 PM
Points: 205, Visits: 10,683
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
Post #1536494
Posted Thursday, February 6, 2014 3:39 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, 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).



Post #1538932
Posted Thursday, February 6, 2014 4:28 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:10 PM
Points: 1,959, Visits: 6,571
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
  • Post #1538942
    Posted Monday, June 15, 2015 10:22 AM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Monday, June 15, 2015 8:20 PM
    Points: 2, Visits: 18
    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.
    Post #1694644
    Posted Monday, June 15, 2015 1:50 PM
    SSC Eights!

    SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

    Group: General Forum Members
    Last Login: Today @ 12:56 PM
    Points: 852, Visits: 1,682
    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"
    Post #1694707
    Posted Monday, June 15, 2015 8:22 PM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Monday, June 15, 2015 8:20 PM
    Points: 2, Visits: 18
    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.
    Post #1694784
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse