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?