Dynamic naming of Excel worksheet tabs issue

[srmoure]

Hello,

I am trying to distribute report by email in excel format where each tab has the name of the staff.  Using page breaks this works perfectly when I run the report.
The issue is when I create a view of the report and I schedule the distribution of the same report, the output received does not have the staff names, but the usual page1_1, page1_2, etc.
The same issue is replicated when I use the bursting function.  I found this strange because the naming works fine when I run the report, the issue is when the reports are sent by email.

Cognos 11.1.2

Any help with this is welcome.

[sdf]

I think you need to have the advanced property to do this.

Here's a link for the setup :

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_ug_cra_adv_prop_name_worksht_tabs_excel2007.html

This is for version 10.2.2 but i guess it's still the same for 11.1.x.

[srmoure]

Thanks, we already have this option and it works perfectly when the report is run. It does't work when the report is bursted or delivered by email through a schedule.

[MFGF]

Thanks, we already have this option and it works perfectly when the report is run. It does't work when the report is bursted or delivered by email through a schedule.

Just a thought. ReportService (which this suggests you set the advanced setting for) is for reports run interactively through the browser. BatchReportService (which isn't mentioned) is for reports run in batch - ie via a schedule etc. Have you tried setting the same advanced setting for BatchReportService?

Cheers!

MF.

[sdf]

 ::) ::) ::)

[srmoure]

Many thanks!!! this resolved the issue !!! (CA 11.1.5)