SSRS 2008: Textbox always on the right side
Hello,and thanks in advance for any answers.I have a quite simple problem, but I couldn’t find a solution yet.There is a textbox in the header of one of my reports, and a matrix in the body below.The matrix is changing its width dynamically based on the data (in this scenario all weeks of the actual year).What I want, is that the position of my textbox is always on the right side of the report, according to the end of the matrix.Actual the textbox is rendered in the middle of nowhere.Is there a any solution? Thanks in advance
February 10th, 2010 10:41am

If you want the textbox to be after the matrix, use the TextBox also in the Body and not in the header. It would be good to put both the matrix and the textbox in one rectangle also. Please let me know if you have any issues :) P.S. : Mark this as an answer if your query is answered
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2010 11:25am

Thanks for your fast answer.If I understand you correctly, this means, that there is no way to position the textbox in the header according to the width of the matrixin the body. Is that right?Actual the textbox is intended to be used in the header.
February 10th, 2010 11:38am

Hmmm, depends on the scenario. Do you have anything like an image in ur header? If so, you will not be able to place a textbox over the image, because when the report is rendered, the textbox would be moved down as overlapping is not supported in html rendering. Or are you making it in the header because you want it to be displayed on all pages? Even then, you can put the textbox in tehbody and achieve the same results. For eg, you can put the textbox in the header of the matrix and set the property to display the header of the matrix on every page. I woule be able to help you more if you could elaborate your scenario a little bit more :)
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2010 12:50pm

Thanks again for you answer.There is no image in the header.The header of the matrix contains all weeks of one year (thus about 52 columns), which are automatically created.The textbox - containing any kind of data (the actual date in most case or static things like this) - is placed directly upon the right end of the matrix (in desing mode).Of course when the report is rendered the width of the matrix increases, while the textbox stays at the same position.My header section often contains report name, creator, date and used filters.It just doesn't look so well, if the textbox is placed in the middle after rendering.
February 10th, 2010 5:19pm

Oh my god, i was thinking till now that you were talking about Report Headers and not Matrix Headers, my bad, sorry! :) Now coming to this, is your requirement just that the textbox should come at the right end of the header? for eg Header W1 W2 W3 W4...... W52 TextBox Body 1 3 5 9 12 If so, you just need to make a matrix, place a textbox immediately after the matrix, and enclose both of them in a rectangle. When it gets rendered, the matrix wil appear first and at the right end of the matrix, u can see the textbox. Please feel free to ask questions if I am nt clear :)
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2010 9:48pm

No, you were right.Maybe my explanation in the last post was quite poor.The weeks are in the header of the matrix, and the textbox in the header of the report (just as you thought in the beginning).Report Header: TextBox-------------------------------------------------------------------Report Body:Header (Matrix) W1 W2 W3... W52Details (Matrix) Value1 Value2 Value3 Value52This is how it looks. The width of the matrix increases (because of the automatically created Header(Matrix)) whereas the Textbox stays at the same position.I should have made a picture right at the beginning.Thanks for your time.
February 11th, 2010 10:25am

Why do u want the textbox in the header? Have it in the matrix header only as an extra column (if you are using SSRS 2008, you can use tablix) and repeat the header rows so that it comes in all the pages. Report Header: ------------------------------------------------------------------- TextBox Report Body: Header (Matrix) W1 W2 W3... W52 Details (Matrix) Value1 Value2 Value3 Value52 If you are using SSRS 2005, add an extra row above the matrix header and right align it so that it always appears in the end. And then enable the repeat header rows property. This will make sure that the textbox is repeated across all pages and appears at the right end of the matrix.
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2010 12:40pm

Hi,Please follow below steps:On last column group top textbox.Add new row - Outside the group (this will add one row on top of matrix)Type your text or expression there. Align it to right of the textboxPreview!Hope it helps!-JayeshPlease vote for answer if it helps you.
February 11th, 2010 12:54pm

Hi Everyone, It is too easy,you have to insert a empty column or columns in the existing matrix/tablix till the end of the report and make sure in design time it shoud not exceed the Page width (Portrait - 8.5 in or Landscape 11 in or Not exceed the Page width). Report Header: Text Box ------------------------------------------------------------------------- Report Body: Header (Matrix) W1 1(empty1) 2(empty2) 3(empty3) Details (Matrix) Value1 Then Hide the 1(empty1), 2(empty2), 3(empty3) columns.By Right clicking entire column -> Select Column Visibility -> Select Hide , on all the empty columns.Now Run the report.You can get the desired result. Report Header: TextBox ------------------------------------------------------------------- Report Body: Header (Matrix) W1 W2 W3... W52 Details (Matrix) Value1 Value2 Value3 Value52 Thanks, Prabu Report Header: ------------------------------------------------------------------- TextBox Report Body: Header (Matrix) W1 W2 W3... W52 Details (Matrix) Value1 Value2 Value3 Value52 SPPrabu
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2011 4:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics