Exporting Groups to Seperate Tabs in Excel 1

[Tatertot45]

I have seen instances of this done in Access and other software, but not Crystal. I have a stand alone Developers version of CR XI, no RAS, no Enterprise, no .NET tools, nothing other than Crystal in a box. I have to export everything and then email it out. Anyway... I'm reportng Itmes and Sales for Grocery chains. I have created Cross tabs for both metrics, i have everything done and the report looks great. When i export it, i use Excel, becuase the sales force understands it. With over 25 stores in this chain, the Spreassheet is really long. IS there a way to put each group on seperate tab? Then the enduser can export the tabs to her subordinates as needed.

Thanks

 

[dgillz]

Check out Visual CUT from Millet Software. Perfect for this application.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Tatertot45]

Visual Cut looks impressive. I like the scheduling part, that would make my life a lot easier.I'll have to check it out.

In the meantime, any ideas on something more immediate?

 

[IdoMillet]

First, I must mention there are other 3rd-party tools. See:

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

While my Visual CUT software can indeed export a single report and make each group a separate excel tab, it sounds like the desired end result is separate spreadsheets with the individual data emailed to each subordinate. This can also be done using Visual CUT. The functionality is called "bursting".

To answer your last question, there is no way to do do this with just Crystal Designer.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Tatertot45]

I realize that there are probably a lot of 3rd party programs out there for Crystal. the desired result is one workbook, multiple tabs. That way the Regional Manager has all the stores at her fingertips, but can export out the tabs as needed, and i don't have to email the RM 100+ spreadhseets. I didn't think CR had this functionality. I took, and passed, Crystal Certified Pro, and never heard about it. I was really just hoping i had missed something.

Thanks for your help...

 

[IdoMillet]

Just to clarify: you could achieve both outcomes with a single scheduled task. A batch file with 2 command lines could first create the multi-tab excel file and then burst and push the individual information to the subordinates.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dgillz]

No version of Crystal does what you want to do - each group on a separate tab of an excel file. You will have togo3rd party.

Ido, Visual CUT does this does it not?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[IdoMillet]

Yes, it does. See the Visual CUT user manual section on "Excel Functionality" -- "Combining Excel Bursting Exports into a Single Multi-Tab Spreadsheet."

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[peterbhols]

Hi,

We are migrating reports from Crystal 8.5 to XIR2.After migration when I schedule the report in BO Enterprise XIthe destination format is EXCEL and
not ( Excel data only).I am not able to see the Page headers or column title after scheduling and viewing in excel format.

thank you

 

[IdoMillet]

Pls start a new thread. Better yet, make it a new thread in the Crystal Enterprise forum.

Cheers,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com