when drag 2 products into page layers and run the report in excel, each product is put in a separate tab. each tab is automatically named page 1 and page 2. is there a way to configure it so that the tabs are name by the product members instead?
Quote from: avuong6 on 21 Jul 2016 04:18:25 PM
when drag 2 products into page layers and run the report in excel, each product is put in a separate tab. each tab is automatically named page 1 and page 2. is there a way to configure it so that the tabs are name by the product members instead?
Are you on version 10.2.2? If so you can try this. (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)
I have not tried this with page layers from CWA but it certainly works for page sets created in Report Studio.