Ihave 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 canclick the twist tie toviewdifferent levelsof detail. Each Zone has many Districts and each District has many Stores. The report renders displaying the summary of the Zones. If you click onthe 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 andStores. 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? ThanksCarolP.S. I tried to upload the code, but it caused my question to be too many characters

If you have the same type of expression as I do, I solved it in this manner: My expression was: =Iif(IsNothing(Fields!ID.Value),true, Iif( Sum(Fields!FixedPrice.Value, "Offer") = 0, false, true))What should it do: If the dataset doesn't return any record then hide the table; if it does and the parent dataset (Offer) has a fixed price filled in, i want to see the table, otherwise hide it. This worked fine in SSRS2000 and SSRS2005. In SSRS2008 this is not working anymore. My solution:=Iif(Sum(Fields!ID.Value)=0, true, Iif( Sum(Fields!FixedPrice.Value, "Offer") = 0, false, true)) It appears to me that IsNothing is not tested anymore... regards,Jefta

I believe I wasn't clear in my description. Here's clarification.The report is formatted:Report Group 1 Header Report Group 2 Header Report Group 3Header Detail LineReport Group 2 Header Row is defaulted to hidden and visibility is toggled on/off ona field in Report Group 1 Header. Report Group 3 Header row is defaulted to hidden and visibility is toggled on/off on a field in Report Group Header 2 row. The Detail line is defaulted to hidden and it's visiblity is toggled on/off by a field in the Report Group 3 Header row.When the report comes up in Report Manager it looks like this:+ Report Group 1 Header Line 1+ Report Group 1 Header Line 2etc.The drill downdisplays as follows:-Report Group 1 Header Line 1 + Report Group 2 Header Line 1 + Report Group 2 Header Line 2+ Report Group 1 Header Line 2---------------------------------------------------Report Group 1 Header Line 1- Report Group 2 Header Line 1 + Report Group 3 HeaderLine 1 + Report Group 3 Header Line 2 + Report Group 2 Header Line 2+ Report Group 1 Header Line 2----------------------------------------------------Report Group 1 Header Line 1- Report Group 2 Header Line 1- Report Group 3 HeaderLine 1 Detail Line 1 Detail Line 2 Detail Line 3 etc.- Report Group 3 Header Line 2 Detail Line 1 Detail Line 2 Detail Line 3Detail Line 4 etc.- Report Group 2 Header Line 2- Report Group 3 HeaderLine 1 Detail Line 1 Detail Line 2- Report Group 3 Header Line 2 Detail Line 1 Detail Line 2 Detail Line 3-Report Group 1 Header Line 2- Report Group 2 Header Line 1- Report Group 3 HeaderLine 1 Detail Line 1 Detail Line 2 Detail Line 3Detail Line 4- Report Group 3 Header Line 2 Detail Line 1 Detail Line 2 Detail Line 3Detail Line 4 Detail Line 5 Detail Line 6---------------------------------------------------The problem is when the report is exported to Excel, the grouping twist ties for Report Group 2 and 3 are lost. The worksheet looks good when it is openend:+ Report Group 1 Header Line 1+ Report Group 1 Header Line 2etc.But once you open the twist tie this is what it looks like:-Report Group 1 Header Line 1 Report Group 2 Header Line 1 Report Group 3 HeaderLine 1 Detail Line 1 Detail Line 2 Detail Line 3 etc. Report Group 3 Header Line 2 Detail Line 1 Detail Line 2 Detail Line 3Detail Line 4 etc. Report Group 2 Header Line 2 Report Group 3 HeaderLine 1 Detail Line 1 Detail Line 2 Report Group 3 Header Line 2 Detail Line 1 Detail Line 2 Detail Line 3-Report Group 1 Header Line 2 Report Group 2 Header Line 1 Report Group 3 HeaderLine 1 Detail Line 1 Detail Line 2 Detail Line 3Detail Line 4 Report Group 3 Header Line 2 Detail Line 1 Detail Line 2 Detail Line 3Detail Line 4 Detail Line 5 Detail Line 6Report Group 2 contains a large number of items so to have the report open completely up as shown above is combersome and awkward. This report is emailed from a subscription on a monthly basis to our client. As you can guess the client is very unhappy. They read this report to determine usage of our services. Does anyone know if the Export to Excel has changed in 2008? All the changes I read about do not appear to apply unless I'm misinterpreting something.How can this be fixed?Thanks in advance.

Hi,I do a test as what you said, however, everything works fine. My test environment is (SSRS 2005 + sp3and office 2007, and SSRS 2008and office 2007). When i export the report with 3 levels to excel,all the grouping twist ties are automatically putted in the worksheet's left outside boudary and i can expand/collapse any hidden item. So, i would like suggest you to check the latest service pack for your reporting service and office version(2007).Hope this help,thanks,Jerry

Jerry,Thank you for suggestion. Unfortunatley, after we applied Serv. Pack 1 and Cumulative update2 and 5 the issue still exists. It looked like there was a fix for the exact problem in Cumulative Update 5, so I'm back to sqare one.Thanks again,Caro

After opening a case with Microsoft, the answer to the problem is to toggle display on the group, not the detail lines. This solved the problem and the report exports to Excel perfectly.

I know this is an old thread, but I may have found another work around: Select the lower (detail) group row handle, right-click, select Add Group (Row Group), select Adjacent Above... Put a 1 in the Group by: field, OK. There should be an isolated group created right above the level of your lower group. Put your header text here, format, etc... then select Hidden: True and use the same ToggleItem as the lower (detail) group. Should look something like this: - Report Group 1 Header Line 1 - Report Group 2 Header Line 1 <Isolated Group(As Header Line)> Detail Line 1 Detail Line 2 Detail Line 3 etc.

I know this is an old thread, but I may have found another work around: Select the lower (detail) group row handle, right-click, select Add Group (Row Group), select Adjacent Above... Put a 1 in the Group by: field, OK. There should be an isolated group created right above the level of your lower group. Put your header text here, format, etc... then select Hidden: True and use the same ToggleItem as the lower (detail) group. It may also be necessary to go into Advanced Mode, reset (Static) rows to Hidden:True removing ToggleItem, and possibly reset the Group to Hidden:True, specifying the ToggleItem. Should look something like this: - Report Group 1 Header Line 1 - Report Group 2 Header Line 1 <Isolated Group(As Header Line)> Detail Line 1 Detail Line 2 Detail Line 3 etc.

Hi, I do not understand what you are saying? You do not mention at all how you changed the toggling to the group. I have a report which i have 7 groups and then the details. I only show 3 of the groups for this particular report, and the last group is toggled by a group 2 levels above. It used to work in SSRS2005 but not working in SSRS2008.