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 ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
