?
Solved

SSRS 2008 Group Header Issue

Posted on 2016-10-19
5
Medium Priority
?
25 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 16

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 16

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

764 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