Keeping Report Items Lined Up with Dynamic Columns
In design view of my report, I have three columns. The third rightmost column is a column group. When the report is rendered, the group extends to nine additional columns. I need to keep the title of my report centered over the total number of columns. I've read that I can do this by inserting a 'static' column group at the top level of my column groupings, but then I can't merge all cells in the resulting row to center the title over the tablix. I need to do a smilar thing with my page number indicator at the bottom of the report so that the text box with the page number always lines up with the right most column in the tablix. How do I accomplish these things? Thank you for your help. cdun2
November 12th, 2010 4:52pm

Hi Cdun2, To your first question “but then I can't merge all cells in the resulting row to center the title over the tablix.”, here you want to merge several columns, we could merge cells in a data region to combine cells, but cells can only be merged within each area of a data region: corner, column headers, group definition (or row headers), and body. We could not merge cells that cross-area boundaries. From your information I guess you might utilize the matrix layout, to work around the issue, you could lay the tablix and title into a table, following these detailed steps to get a reference: 1. Drag a table to your report body with only one column. 2. Delete its detail row to have just two rows. 3. Type in the Title text in the upper cell of the newly created table, and then set the text centered in this cell. 4. Drag the Matrix into the under cell, adjust its width/length to satisfy your need. After these settings, preview the report, the Matrix’s “title” text should always be centered. To your second question “page number indicator at the bottom of the report so that the text box with the page number always lines up with the right most column in the tablix.”, as built-in field Globals!PageNumber could only be utilized on report footer and textbox’s location is static, so currently we might not be able to control pagenumber’s loction dynamically. Thanks, Challen Fu
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 2:58am

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

Other recent topics Other recent topics