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...
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 (http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kbcdr&uniqueid=114219)