SSRS 2008 Group Header Issue

Hello experts -

We are in the process of upgrading from SSRS 2005 to SSRS 2008 and I have come across a puzzler. A 2005 report that contains a group with a header row renders fine in 2005 report manager, but when viewed in 2008 only the first group header is moved all the way over to the right of the report. All the successive group headers are fine. Please see the attached report for a better explanation of what I mean.

Does anybody have any experience with this? I am not sure where to look next. When I pull the report(s) directly off report manager into the 2008 designer (Visual Studio), they both render fine. Somehow when they are deployed to report manager something is reading something else incorrectly (???).

Help :)

-- Lisa
Group-Header-Alignment-Issue.docx
Lisa CallahanBusiness Intelligence AnalystAsked:
Who is Participating?
 
Lisa CallahanBusiness Intelligence AnalystAuthor Commented:
I fixed it. It has something to do with how 2008 organizes groups into parent-child hierarchies. I had to delete the parent group, re-add it as a parent group with a header, hide the parent group column, and then add the expression into the group header.

And we have only 7,000 reports to review for this change.

Good times.
0
 
Megan BrooksSQL Server ConsultantCommented:
I think I would start by looking at the HTML to see if the browser is rendering the headers as expected, and whether the HTML for the first group header is the same as that for the second. Have you tried it with more than one browser?

Another quick check would be to look at the 2008 RDL (XML) for anything suspicious, such as a buried conditional expression that behaves differently after migration. Unlikely, but easy to check for.

Is the group header row defined as merged cells, so that there is only one cell?
0
 
Lisa CallahanBusiness Intelligence AnalystAuthor Commented:
It doesn't render at all with Chrome. None of the SSRS 2008 report manager reports work. Which seems to be a whole different issue. This issue is with IE. It looks like it is the first header on each page only. So it must be something with a page break. I will keep looking.
0
 
Megan BrooksSQL Server ConsultantCommented:
In many if not most applications, the parent group column is not needed. I delete it, preserving the group itself. One would expect that groups would migrate properly, but oh well. How did you hide it? My recollection is that it won't hide,
0
 
Lisa CallahanBusiness Intelligence AnalystAuthor Commented:
I fixed the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.