Hey all,
I'm using an integrated version of Crystal Reports 9 and am racking my brain with a few things on my invoice report.
In my @WorkLocation field, it adds 2 lines I don't care much for and would like to remove. Currently it's giving me:
Primary
First Name Last Name
Attn: First Name Last Name
Address
City, State, Zip
How would I go about removing the "Primary" and Attn: Lines? I also have that annoying Attn: line in my @BillToLocation field as well.
I can't seem to figure out what I'd need to modify in the formula, or if that's the right place to be.
@WorkLocation looks like this currently:
formula = ""
'Use the header?
IF NOT ISNULL({Invoices.WorkLocation_Header}) THEN _
IF {Invoices.WorkLocation_Header} <> "" THEN _
formula = {Invoices.WorkLocation_Header} & CHR(13) & CHR(10)
'Use the body?
IF NOT ISNULL({Invoices.WorkLocation_Body}) THEN _
IF {Invoices.WorkLocation_Body} <> "" THEN _
formula = formula & {Invoices.WorkLocation_Body} & CHR(13) & CHR(10)
'Trim any trailing carriage return?
IF RIGHT(formula, 2) = CHR(13) & CHR(10) THEN formula = LEFT(formula, LEN(formula) - 2)
IP Logged
