Developing a Crystal Report in text format
Developing a Crystal Report in text format
(OP)
HI
I am developing a Crystal Report in text format but my columns are not aligning as to the number of spaces that are to be in each field, such as the last name field is to be 13 space field size, first name is to be 10 space field size, etc.
I have this as one of the formulas:
stringvar padSpaces:=space(250)
The following is the formula I have for each of the field names. When I try to save this formula, it is stating that the ,13)is an error in the formula. Any suggestions?
stringvar myString:="";
mystring:=
left({OFFENDERS.LAST_NAME}+{@spaces}),13)
I am developing a Crystal Report in text format but my columns are not aligning as to the number of spaces that are to be in each field, such as the last name field is to be 13 space field size, first name is to be 10 space field size, etc.
I have this as one of the formulas:
stringvar padSpaces:=space(250)
The following is the formula I have for each of the field names. When I try to save this formula, it is stating that the ,13)is an error in the formula. Any suggestions?
stringvar myString:="";
mystring:=
left({OFFENDERS.LAST_NAME}+{@spaces}),13)
RE: Developing a Crystal Report in text format
stringvar myString := "";
stringvar lname := "";
if isnull({OFFENDERS.LAST_NAME)) then
lname := "" else
lname := {OFFENDERS.LAST_NAME);
myString := left(lname+{@spaces}, 13);
-LB
RE: Developing a Crystal Report in text format
RE: Developing a Crystal Report in text format
-LB
RE: Developing a Crystal Report in text format
RE: Developing a Crystal Report in text format
-LB
RE: Developing a Crystal Report in text format
00000000000000 0000000(13sp) 000000(10sp)0000000000000000000000000000000000000000
00000000000000 0000000(13sp) 000000(10sp)0000000000000000000000000000000000000000
00000000000000 0000000(13sp) 000000(10sp)0000000000000000000000000000000000000000
When I took the formulas out of that text box to export it to a text format, the data does not line up correctly - also when I export it from the correct format in Crystal Reports to a text format, it comes out like this example rather than the 1st example above.
00000000000000 0000000 0000000 000 0000000000000000000000
00000000000000 0000000 00000 000 0000000000000000000
00000000000000 0000 00000 000 00000000000000000000000000
I am confused as to why when I export it to a text file that it messes up everything (looks like the second example) instead of like the 1st example. I thank you so much for your time. I have been working on this for weeks to no avail but am getting some ground thanks to you.
RE: Developing a Crystal Report in text format
Have you tried exporting to different text formats? Tab-separated text, csv, text?
-LB
RE: Developing a Crystal Report in text format
if isnull({PS_TC_CPAS_DETAIL.MAILING_CITY})= yes
then space(30)
else {PS_TC_CPAS_DETAIL.MAILING_CITY}& space(30-length({PS_TC_CPAS_DETAIL.MAILING_CITY}))
I hope this helps.