Hello Team,
I need to get rid off the excel numbering ,when the output is generated.
As per the attachment, I have 3 Pages in Report Studio
1.Deal(1,2)
2.Deal(3,4)
3.Deal(4,5).
When the Output is generated, It is coming as Deal(1,2)_1 , Deal(3,4)_2.
I tried to select the page and in properties -> Pagination ->Reset Page count/Page number ---> 1. But that feature is not working.
Request you to advise on this.
Are you, perhaps, looking for a way to deliberately name tabs in Excel output?
https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=niv1-dynamically-rename-excel-sheet-in-multi-tab-excel-output
Or maybe keep all of the data on one page together on a single tab, if possible?
https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sa-configuring-report-batch-report-services-use-large-worksheets
Thanks a lot. I have applied the changes at the dispatcher level . It is working as expected.
Regards,
Swetha :)