Help in Excel output

[gops210]

 Hi,
Ã,  Ã,  Ã,  I have a report in which i take the excel output,Actually i have given a page break for a grouped column,so when i take the output in excel it shows seperate sheet each data...This is fine

but my requirement is i wanted to have my query item data value to be named as sheet name

for example if i have [product line] [Product Name] if i have applied grouping to Product line...i should get the product line data which comes in the single sheet should go to the name of the sheet...

I have tried a lot but none of them gave me anything.....Please suggest me regarding this..

Thanks in Advance...

[MDXpressor]

According to the Cognos Knowledgebase, the only way to dynamically name pages is via SDK.

http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kbcdr&uniqueid=114219