COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: V i n c e n t on 24 Jun 2011 09:43:05 AM

Title: multiple excel output
Post by: V i n c e n t on 24 Jun 2011 09:43:05 AM
Hi,

Is it possible to générate a report for each member of a value in one time ?

for example :

Each coutry générate an exel report with products, revenue, qt

I know how to do with a pageset if would a sheet by country but not one file by country.

Thanks for your help



Title: Re: multiple excel output
Post by: PRIT AMRIT on 26 Jun 2011 09:45:11 AM
Can do bursting to file location by country. So each will create Excel file for each country.

Title: Re: multiple excel output
Post by: V i n c e n t on 27 Jun 2011 06:22:19 AM
can you explain please ?
Title: Re: multiple excel output
Post by: MFGF on 27 Jun 2011 08:20:08 AM
Quote from: V i n c e n t on 27 Jun 2011 06:22:19 AM
can you explain please ?

The best thing to do is to take a look at the Report Studio user guide - chapter 14.

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/8.4.1/ug_cr_rptstd.pdf

Regards,

MF.
Title: Re: multiple excel output
Post by: V i n c e n t on 27 Jun 2011 09:40:14 AM
ok thanks

I understand how to do but i always have a problem.

How to export with différent file name. (usa.xls, germany.xls, france.xls )
(without administration acces to modify CM.OUTPUTSCRIPT)

now i have that
report.xls (for usa)
report.xls (for germany)
etc.

Thanks for your help