I have an RDLC report which I am designing using Visual Studio 2010. I create 2 groups as I want to be able to collapse Group 1 (top most) at will and/or Group 2(second layer) at will. The detail section starts off hidden and can be collapsed by Group 2.
To make this happen, in Group 2 properties, I changed the visibility properties to HIDE and togglebyitem=the field from Group 1 where I want to add the plus/minus. in Detail section, I changed the row group visibility properties to HIDE and togglebyreportitem=the field from Group 2 where I want to add the plus/minus.
When running the report, it works like a charm when in preview. However, when I save or print to an Excel spreadsheet, it doesn't seem to render properly. I.e., when I collapse Group 1, I see all the group 2 rows as expected PLUS one record from Detail section. It shouldn't really display the detail section as this is still uncollapsed at this time. Then when I collapse Group 2, I see all the detail section plus that 1 duplicated row that was displayed to begin with.
This is really weird. I have a feeling this is beyond my control as I don't really control how NAV converts to Excel. But I am hoping I am doing something wrong to generate this anomaly. Thoughts?
