Solved

SSRS 2008 Group Header Issue

Posted on 2016-10-19
5
19 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:Lisa Callahan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:Lisa Callahan
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:
Lisa Callahan 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:Lisa Callahan
ID: 41858262
I fixed the issue.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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