Export from CR9 to Multi Tab Excel Spread Sheet.

[cmd7271]

I am not sure if Crystal does this...

I am looking for a way to export from CR9 to excel and figure out a way to have the output be placed into DIFFERENT tabs in excel. For example I want the data in certian part of the report to be in TAB A in excel and data from other parts of the report to be in TAB B in the same excel spreadsheet.

Is this possible?

 

[synapsevampire]

I don't think so, but you could create an Excel spreadsheet with a macro/vba code to read in the exported data afterwards and do this.

-k

 

[IdoMillet]

I just finished enhancing Visual CUT to provide this functionality (Combining Excel Bursting Exports into a Single Multi-Tab Spreadsheet).

Contact me if you want to test drive it.

Cheers,
- Ido

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

http://www.MilletSoftware.com