Worksheet name in Excel output
A report has three list report objects (Sales by products, Sales by region, and Sales by order method). Users prefer to access it in Excel format.
They want the three reports to be populated on three different sheets and each sheet should be named appropriately.
Getting ready
Create a report with three list report objects and pull appropriate columns in each.
How to do it...
To generate different names for the sheets in Excel, we will create different pages in the report and give each page a meaningful name.
Open Page Explorer and add two new Page objects as shown in the following screenshot:
Select each of them and change their names in properties to the names shown in the following screenshot:
Now cut the list objects from the first page and paste in the appropriate report page.
Run the report in Excel to test it as shown in the following screenshot:
As you can see, Cognos produces three sheets with the names the same as what we defined for Page name (with an auto...
