Hi,
I'm using Cognos 8.2 version.
I'm having one crosstab Report, page name as "Country" and the data items are Country (Grouped), Product names, Current forecast, and Actual forecast. I have created one page set to display details by countrywise in separate pages.
I'm having 11 Countries and in excel 2002 output, 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 replace by Country names.
For ex: If the sheet1 contains details on India, then the page name should be India instead of Country-1.
Please anyone help me on this.
Thanks in Advance
Can any one help me on this?
Eagerly waiting for an answer from Cognos greats...
AFAIK this not doable from the Cognos side. Technically you could write a VBA procedure that performs this action from within Excel, based on a cell value. This however would only make sense if you can open an Excel template that stores the VBA procedure. By default Cognos opens a standard empty Excel workbook..
Ya, that was what I too guessed. An excel macro would do the trick. But you will have to code the macro in the excel, before distributing...