Solved

SSRS 2008 Group Header Issue

Posted on 2016-10-19
5
12 Views
Last Modified: 2016-10-25
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
0
Comment
Question by:ldcallahan
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Megan Brooks
ID: 41851200
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
 

Author Comment

by:ldcallahan
ID: 41851930
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
 

Accepted Solution

by:
ldcallahan earned 0 total points
ID: 41852082
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
 
LVL 14

Expert Comment

by:Megan Brooks
ID: 41853242
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
 

Author Closing Comment

by:ldcallahan
ID: 41858262
I fixed the issue.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now