I have developed some reports using a tablix with Row Groups. When this is exported to excel this gives a nice pivot table with a + sign to expand the detail rows. What I would like it to be however, is a list that contains ONLY the parent rows. Can I not test on the RenderFormat = EXCEL somewhere and don't show the details. (I don't mean hidden, but not present?) thanks, Jan

Hi Jan, Thanks for your question, I get your meaning completely, you want to display the tablix with toggle function on reoprt, but having only one parent group without toggle function when exports to Excel, right? If so, I think there is no build-in featurn to achieve this requirement, to work around the issue, you could design two different tablixes, one has toggle function within different row groups, one has no toggle function within only one parent group. Then set first tablix's hiden property based on expression =IIF(Globals!RenderFormat.Name="EXCEL",true,false) Set second tablix's hiden property based on expression =IIF(Globals!RenderFormat.Name="EXCEL",false,true) Preview the report, you will have first tablix displayed, export to excel, you will have the second tablix displayed. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.