CRYSTAL REPORTS-MICROSOFT EXCEL export formatting

mbroad02
mbroad02 used Ask the Experts™
on
Ok I have a new one.  I created a Crystal Report which formats the fields on the report to be specific lengths (using command Left((FIELDNAME) + Space (16), 16) for example).
I need to be able to export this report (the fields on the report) to an excel spread sheet.  
I tested this and the fields show up just fine, but the columns in the report do not vary based on the sizes of the fields.  If I have fields F!, F2 and F3 (lengths 12, 20 and 30), i would like Excel to set a width of 12, 20 and 30 respectively as I export the fields.
Is there a way to do this?
thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
When exporting the report to Excel, in the Excel Format Options dialog box that pops up, set the Excel Format to Custom, and click the "Options" button. In the Options dialog, set the "Column width based on objects in the" option to the desired option, in this instance it would likely be the Report Header or the Details line
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:

Author

Commented:
Maybe I am trying to do too much; something that Crystal/Excel cannot do.  The formatting options and directions you suggested are not working.  Please see the attached--this shows what options I have tried, the results I am getting and what I am trying to do.
Maybe I am doing something wrong...  ?

Any help would be appreciated.
thanks
Excel-export-issues.doc
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
I don't know except that we ignored the export ability to Excel for that reason.

mlmcc

Author

Commented:
If I export to a CSV or TXT file, using the fixed-length fields, and import into Excel, would that get me what I want?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
It might.

mlmcc

Author

Commented:
No--that doesn't work either.   Am I "sunk" or is there ANY way to get this to work?
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
I got what I needed by writing code in VB to export the report data and created the spreadsheet.  I had full control over the format of the Excel file.

Another way would be to look into a third-party solution.  Here is one that is supposed to  give you control over the export
http://www.milletsoftware.com/Visual_CUT.htm

mlmcc

Author

Commented:
Thanks mlmcc--can't buy a product (for work)--oh well--thanks anyway

Author

Commented:
I am sorry that I cannot give a higher grade but the answers failed to fix the problem.
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial