Solved

SSRS EXCEL Export isn't showing all my Groupings

Posted on 2015-02-11
1
93 Views
Last Modified: 2015-03-02
I'm having issues with a report that was developed in SSRS 2005.  This report has 5 groups and all five wold show in SSRS2005 when you export to excel.  Now that we are on SSRS 2012 it only shows 2 groups.  Not sure why that's happening.  I will attache pics so you can see what I'm talking about.

As you can see we have 5 groups
This is what is should look like where you can pick any grouping you want.   You can see all 5 groups at the top
This is what we have now where it only shows two groups along the top and only select two groups.
The report hasn't been modified other then we moved to SSRS 2012.
0
Comment
Question by:abarefoot
[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
1 Comment
 
LVL 1

Accepted Solution

by:
abarefoot earned 0 total points
ID: 40640583
I recreated the report and it fixed my issue.  Something strange must have happened when the file was converted.  This is the second question I've ask where no one helped.  Experts Exchange is going down hill while their price is going up.  STRANGE.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

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…
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.   …

751 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