Solved

SSRS 2008 Group Header Issue

Posted on 2016-10-19
5
23 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 15

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 15

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

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

705 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