Repor output in excel sheet wise with Name.

[govicognos]

Hi All,

I'm using Cognos 8.4 version.

I'm having created one List Report, In that list Data items are Country,Product name,Product line.. so on and I applied setction On Country , Product names,Product line .. and rest of data item normal data items i have not applied any thing that all are normal . Display details by countrywise in separate pages.
I'm having 11 Countries and i want output in excel 2002 or 2007 Format, 11 Countries are displaying in 11 separate sheets. Sheet names are Country-1, Country-2, Country-3...., Country-11(Report page name-1, Report page name-2 etc). But my requirement is the sheet names should rsame as my Country names.
For ex: If the sheet1 contains details on India, then the page name should be India instead of Country-1.

[Lynn]

Search the forum....this question has been asked zillions of times.

http://www.cognoise.com/community/index.php?topic=15888.msg52899#msg52899