Solved

SSRS EXCEL Export isn't showing all my Groupings

Posted on 2015-02-11
1
82 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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 …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
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…

895 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

11 Experts available now in Live!

Get 1:1 Help Now