Display of respective Product name on Excel sheet names dynamically

[Sarayucog]

Hi All,

I am using Cognos 10 Version. I have a report with Product Line, Product and Revenue and I have applied page by based on Product Line. So my report output is giving each Product Line per page when I run the report in HTML format.

If I run the same report in EXCEL 2007 format. Its giving the output as each product line in each sheet. Here my problem is sheet names are displaying as Sheet1, Sheet2, Sheet3, Sheet4 and Sheet5. Instead of these default Sheet name names I want to display the sheet names as respective Product Line names dynamically. Its very urgent to me.

Can you please guide me on this to achieve.

Your help would be appriciated more.

[tjohnson3050]

This topic comes up repeatedly.  See previous thread:

http://www.cognoise.com/community/index.php/topic,15888.msg52899.html#msg52899