Grouping Problem when export from Reporting Services to Excel
Posted on 2010-03-23
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?