Far right column header on second page and beyond is stretching beyond page width. SSRS 2008
I have a report with the five right-most columns set to dynamically be visible based on selections of a parameter. When I first built the report a few weeks ago even if all five columns were selected to appear via the parameter than all the columns on the report would fit on a 8.5*11 sheet of paper in landscape orientation. If less than the 5 dynamic columns were selected than the report displayed only the selected columns and the selected columns were correctly spaced based on the width settings. At this point everything worked perfectly. Today I added two columns to the middle of the report, they aren't dynamically based on a parameter so they always show up. I set the report to default to just 2 of the dynamic columns to be visible upon running the report. This allow for all the columns to fit easily on one page. When I run the report the first page is rendered perfectly, but on the second page an beyond the column to the far right stretches about three time the size I have it set to based on its width property. The column ends up stretching and causing an additional (un-needed) and blank (other than the one header field) page. I've confirmed that I've set all the columns and fields so that they can't "Grow". But I'm not sure what else could control this issue. Are there independent settings for how the header is displayed on the 2+ pages as opposed the the first page?
December 24th, 2010 5:42pm

Just wanted to update this with a semi fix that I came upon by trying different things. My report had two header rows, this was done primary to have a summary above the different columns to indicate whether the columns were for the prior year, current year, or next year. It was under the next year columns that I was having the problems as these were the five columns that could be shown dynamically via a parameter choice. What I did was to have the second header row with the column names display on every page and the first header row only display on the first page. I achieved this by setting the top/first header row's "KeepWithGroup" property to "None", and the second header row's "KeepWithGroup" property to "After". By doing this the column to the far right retains its proper size on all pages. So I lose the summary header row on all but the first page but this is acceptable and I feel won't cause any issues with the users. Anyway it's not perfect but it works.
Free Windows Admin Tool Kit Click here and download it now
December 26th, 2010 9:13pm

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

Other recent topics Other recent topics