Creating Mulitple Reports and Excel

[Former Member]

I have created a sale report in CR 2008. This report looks at each reps performance on a monthly basis. The reports need to be run daily and sent to the Sales Managers. Each manager has several reps that report to them. I need to know if I am able to run this report for several reps at once, but show up on separate reports? Can I take these results and put them on separate worksheets in one workbook in excel? This is the last step in the report creation process and it is driving me crazy. It is not efficient to have someone rerun the same report for the 40+ sales reps we have in our company and then copy and paste them into seperate tabs in excel. Any help would be greatly appreciated.

[former_member292966 · Accepted solution]

Hi,

Unfortunately Crystal cannot export reports to multiple tabs. InfoView can but that's another beast in itself. In the past I've created a small app to run the report x times and have each report exported to an XLS file. The program opens an Excel workbook and saves each XLS file to a new worksheet.

I have heard of a couple of utilities that will do this for you and I've looked at them but they never did work out to what I would have liked.

Good luck,

Brian

[Former Member · Accepted solution]

Hi Brian - Thanks for responding. What program did you use to create the small app?