Saving output into multiple excel sheets

[umag]

Hi
I am trying to explore different option available for my question.

I have a report which runs every month on a scheduled time and saves the output into pdf and excel formats. This report has page break on primary item say company name. The pdf format is fine as I am giving page break on company name, but users wanted the excel output to be saved in different excel sheets for each company name as they want to send this information to those companies individually. Let us say report has 15 companies and users want the excel output to be saved in 15 excel sheets so that it is easy for them to send a file to each company. Right now it is saving in one excel sheet and users are cutting and pasting making one excel sheet to 15 (depends on number of companies in the report) excel sheets.

what are the options available to me?

Appreciate your help

Regards
Uma

 

[nagrajm]

Introduce a prompt in the filter condition for "Company Name" or "Company Code".

The value for prompt may be supplied to the report either;

1) in the macro that runs the report every month. I am not a macro expert but I know that it can be done.

2) in the IWR by creating a report for each "company name" and supplying the prompt in the "prompt" tab in the Report Administration tool.

This will create one PDF and one excel file for each company.

Hope that helps.