Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lookingforK on 08 Aug 2014 03:19:46 PM

Title: How to automatically generate multiples reports in Excel format?
Post by: lookingforK on 08 Aug 2014 03:19:46 PM
Hi,

I am using Report Studio 8.4.1.

I just want to know: How to automatically generate multiples reports in Excel format and save them to a specific folder?

For example, I made a report for store sales. There are 30 stores. Can I automatically generate 30 reports for each store and save these Excel files to a pre-defined folder on a network driver?

Thank you.
Title: Re: How to automatically generate multiples reports in Excel format?
Post by: Raghuvir on 29 Dec 2014 09:49:39 AM
Quote from: lookingforK on 08 Aug 2014 03:19:46 PM
Hi,

I am using Report Studio 8.4.1.

I just want to know: How to automatically generate multiples reports in Excel format and save them to a specific folder?

For example, I made a report for store sales. There are 30 stores. Can I automatically generate 30 reports for each store and save these Excel files to a pre-defined folder on a network driver?

Thank you.

Hi,

yes this is possible.

You will need to burst the report by using the report burst option in the file menu.

Regarding the saving of the excel files on a folder, you will need to use directory bursting.

Regards
Title: Re: How to automatically generate multiples reports in Excel format?
Post by: lookingforK on 29 Jan 2015 11:17:37 AM
Thank you.
Text only | Text with Images