Posted 22 June 2020, 8:07 am EST
I am new to AR and have recently inherited a project using AR v12. I see that as part of AR v11, feature request ID: 207299 implemented a new property of the ExcelRendingExtensionSettings object called SheetName. When paired with the MultiSheet property, I have seen this generate results like Sheet1, Sheet2, etc (with SheetName by default being set to “Sheet”). Is there a way to dynamically name the sheets based on the data that the report is breaking on? e.g. if I am page breaking on a field “Region” with values like North, South, Central, etc…is there a way to name the sheets something more relevant than Sheet1, Sheet2, Sheet3?