IÃÂ have a reportÃÂ created in SSRS 2005 which is running on our new SSRS 2008 box.ÃÂ It has 3 nested levels of visibility so the recipient canÃÂ click the twist tie toÃÂ viewÃÂ different levelsÃÂ of detail.ÃÂ Each Zone has many Districts and each District has many Stores.ÃÂ The report renders displaying the summary of the Zones.ÃÂ If you click onÃÂ the twist tie on the Zone it opens up a list of Districts.ÃÂ If you click on the twist tie on a district, it opens up a list of stores.ÃÂ If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.
The report renders fine in report manager.ÃÂ The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.ÃÂ The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts andÃÂ Stores.ÃÂ The client is not happy about this.ÃÂ This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.
I tried converting the report to SSRS 2008, but that did not solve my problem.ÃÂ
Is there anyway to fix the export process to Excel?ÃÂ
P.S. I tried to upload the code, but it caused my question to be too many characters
View Complete Post