fix field with in crystal export to text

[needmoremoney]

Hello,

I'm working on this report and need some help.

specs:

Fixed Length ASCII

Position Field Size Details
1-1 Transaction C 1 I or V
2-8 Company Name 7 Left justified, space padded
9-18 Account number 10 Right justified, leading zeros
19-28 Check Number 10 Right justified, leading zeros
29-34 Check date 6 0M0DYY
35-44 Amount 10 Right justified, leading zeros, implied decimal
45-46 CR/LF 2 Record Terminator


Any help ... thanks a million. I don't know how to format the fix size and the justification. All of the fiels exists in one text field.

 

[ShortyA]

Hi,
need a bit more info to start with...
what version of Crystal Reports are you using ? What type of database are you reporting off of ? What is the purpose of the report ?

ShortyA

 

[Madawc]

You can get leading zeros for numeric fields in Crystal, using Totext({a.number}, "000000000"). This means that 7123 will come out as 000007123. Does this help?

Madawc Williams (East Anglia, UK)

 

[needmoremoney]

Madawc... that did the trick. But I need one more thing. I need to specify each field to be only a specific length. For example, the field must have 8 chars, so if I pull data that has only 4 chars, the data would display:

" GOOD"

By the way, I'm using crystal 8.5 with access 97 and access 2000.

thanks for all the help people. )

 

[Madawc]

Right-justify your text?

Madawc Williams (East Anglia, UK)