Renegade800
Programmer
I've got a cross tab report. One of the column is a formula I've created containing the address of a supplier. Since there are 3 lines for the address in the database and some are left blank from time to time, the formula is as follow :
Local StringVar adr1;
Local StringVar adr2;
Local StringVar adr3;
if {CP_MAIT.ADR1} <> "" then adr1 := {CP_MAIT.ADR1} & chr(13) & chr(10);
if {CP_MAIT.ADR2} <> "" then adr2 := {CP_MAIT.ADR2} & chr(13) & chr(10);
if {CP_MAIT.ADR3} <> "" then adr3 := {CP_MAIT.ADR3} & chr(13) & chr(10);
{CP_MAIT.NOM} & CHR(13) & chr(10) & adr1 & adr2 & adr3 & {CP_MAIT.CODP}
The report appears fine when viewed with Crystal Report. When I export it to Acrobat reader format, only {CP_MAIT.NOM} appears in the column. At first, I've only used chr(13) for the carriage return, then I've added chr(10) for the line feed. In both case, the remaining of the formula is missing.
Local StringVar adr1;
Local StringVar adr2;
Local StringVar adr3;
if {CP_MAIT.ADR1} <> "" then adr1 := {CP_MAIT.ADR1} & chr(13) & chr(10);
if {CP_MAIT.ADR2} <> "" then adr2 := {CP_MAIT.ADR2} & chr(13) & chr(10);
if {CP_MAIT.ADR3} <> "" then adr3 := {CP_MAIT.ADR3} & chr(13) & chr(10);
{CP_MAIT.NOM} & CHR(13) & chr(10) & adr1 & adr2 & adr3 & {CP_MAIT.CODP}
The report appears fine when viewed with Crystal Report. When I export it to Acrobat reader format, only {CP_MAIT.NOM} appears in the column. At first, I've only used chr(13) for the carriage return, then I've added chr(10) for the line feed. In both case, the remaining of the formula is missing.