Export to a multiple worksheet

[back2tek]

Hi all:
I am using CR9 to report off SQLSever 2000. I am looking for a solution to automate report generation that will allow unrelated reports ( for example sales per agents report and monthly sales summary report) to be exported in one Excel sheet on 2 different worksheets.
Can this be done thru Crystal?

Thank you for your help...

Back2Teck

 

[IdoMillet]

Do you mean each report export going to a different sheet (tab) in the same excel workbook? If so, Crystal alone can't do this, but consider a 3rd-party tool (see list at:

http://www.kenhamady.com/bookmarks.html).

My "Visual CUT" software can do this. If you search the user manual for "TabInOldFile" you'll find the correct section discussing this functionality.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com