Excel Numbering

[Swetha]

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.

[dougp]

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

[Swetha]

Thanks a lot. I have applied the changes at the dispatcher level . It is working as expected.

Regards,
Swetha  :)