asked on

Crystal Reports--fixed field lengths for output

I need to create a crystal report which will also be used for Export to an Excel file. For the Excel file, it is required that each field be a specific length (see the attached template). Is there a way in Crystal to set lengths of each field?
Your help is appreciated.
Thanks
IFAS-template.xls

ASKER CERTIFIED SOLUTION

aelliso3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbroad02

ASKER

That works just fine--thank you. But if I can get a bonus question answered in this:
I also need to remove the first 2 characters of the field I am formatting before I print it. I create a field called INVOICE_NO, removing dashes from the CASE.DSCR and formatting the date (appended to the CASE.DSCR.
Then I limit the INVOICE field to 16 characters.
BUT, before I print, I need to remove the first two characters (leftmost).

Example formula code:
stringVar INVOICE_NO := Replace({REAL_CASE.DSCR},'-','') & "-" & Totext({APPTPMT.PMT_DT},"MM/dd/yy");
stringVar PRINT_INVOICE := Left({@INVOICE} + Space (16), 16);
PRINT_INVOICE;

If you can assist--I truly appreciate it.

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbroad02

ASKER

Thank you for all of your help!!

James0628

You're welcome. Glad I could help.

James