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.
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 (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.
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.
Quote from: srmoure on 06 May 2020 12:47:50 AM
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.
::) ::) ::)
Many thanks!!! this resolved the issue !!! (CA 11.1.5)