Report Painter Section Name

[Former Member]

Hello,

I have been creating reports with sections in Report Painter so that it can be downloaded into Excel and each section is on a separate excel sheet. This is all good, but my question is, is it possible to put a variable (eg. cost center / cost center group) in the "name" field of the section. Until now I have only created sectioned reports with fixed cost centers setup behind each section, and I know I can also put a variable cost center (or cc group) behind the section, but I do not know if it is possible to put the variable cost center in the "name" field of the section, so that the resulting excel will have the name of the cost center as the worksheet name. I have tried to put the variable with & and $ but they do not work, it is treated as simple text.

Thank you

[Former Member]

Unfortunately no 😞

[Former Member]

Hi,

I was trying to do the same but no luck so far. Have you or anyone else been able to find out a way to do this.

Thanks.