extract excel output for different months in different tabs

[PrawinM]

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

[Lynn]

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

[PrawinM]

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

[Lynn]

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.