HI ,
i got this requirement please help me :
i have a basic adhoc report , users expecting a excel output format as each month data in each tab from October 2017. For example if run for jan the excel ouput will be 4 tabs as October 2017,November 2017,December 2017 and January 2018 .
Thanks,
P.K
Quote from: PrawinM on 09 Jan 2018 11:34:47 AM
HI ,
i got this requirement please help me :
i have a basic adhoc report , users expecting a excel output format as each month data in each tab from October 2017. For example if run for jan the excel ouput will be 4 tabs as October 2017,November 2017,December 2017 and January 2018 .
Thanks,
P.K
A page set will allow you to break pages by month and these will render as separate tabs when run to Excel. There is a server setting that needs to be made in order for the tabs to be named based on the grouping of the page set (e.g., October 2017, etc).
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_cr_rptstd_frmat_rep_create_page_sets.html
Thanks a a lot for helping i did the change but am getting date format as "2016-09-30T00_00_00.000","2017-01-31T00_00_00.000" etc...
Pl;ease help me to avoid this.
Thanks,
P.K
Quote from: PrawinM on 15 Jan 2018 01:30:27 PM
Thanks a a lot for helping i did the change but am getting date format as "2016-09-30T00_00_00.000","2017-01-31T00_00_00.000" etc...
Pl;ease help me to avoid this.
Thanks,
P.K
I am guessing that you are using a date or date/time field as the page break in your reports. Try casting the date as a string in the desired format and use that as the page break.