Grouping Problem when export from Reporting Services to Excel

I have an report designed in Reportbuilder 2.0.  I am query data from SQL and retuening grouped results with averages for each group level.  The problem is it all looks good when run in report builder or run on the report server from the web browser, but on export to excel, the grouping does not line up the same as in the report builder.  Levels that should be hidden until expanded are showing on initial opening of tghe file.  Any ideas?
bklughAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

redrumkevCommented:
bklugh,

How are you doing?

See this link (under heading - Interactivity -> Show and Hide):
http://msdn.microsoft.com/en-us/library/dd255234.aspx

Are you using more than 7 levels or have you violated any of the rules listed? If so, you need to think of another way around this (from your RB 2.0) that works with Excel.

Hope this helps,
Kevin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bklughAuthor Commented:
We ended up finding our own solution by inserting a new detail row above the group which corrected the problem.  the link provided however, was most helpful as we expand the report's capabilities.  Thank you.
0
redrumkevCommented:
bklugh,

Glad it helped out,... expanding capabilities is never a bad thing!

Thank you for the grade,
Kevin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.