CODEWITHSUNDEEP
crystal-reportscrystal-reports-xicrystal-reports-2016
Kelly
Kelly

Reputation: 1

Multi-line Fields in Crystal Reports

I am working on a report in Crystal Reports 2016. The table used by the report, USER_ADDR, stores the addresses in its ADDRESS column, storing additional information about the address (ex: apartment #) in a second line.

USER_ADDR Table

ACCOUNT_ID ADDRESS_LINE ADDRESS
1 1 1234 Orange Ln
2 1 1259 Apple Dr
2 2 APT 209
3 1 4962 Kiwi Pl

I am using the field USER_ADDR.ADDRESS to show the address, but it only shows the first address line, which does not show the complete address if an account has an ADDRESS_LINE of 2.

  1. How would I go about making a formula in Crystal Reports to show all lines of the ADDRESS column when an ACCOUNT_ID has an address where ADDRESS_LINE = 1 and 2.

or

  1. How would I make a formula that only includes an ACCOUNT_ID's address where ADDRESS_LINE = 2

For reference, the report I'm modifying has the below columns:

Account Address Line 1 Address Line 2

Thank you!

What I've tried: opened the Format Editor and selected the "Can Grow" option, hoping that would allow ADDR.ADDRESS to be multi-line but that did not work.

Upvotes: 0

Views: 521

Answers (1)

MilletSoftware
MilletSoftware

Reputation: 4026

Use a detail-level formula to declare a global string variable and append the information using Chr(10) + Chr(13) to inject new lines. Reset the variable in the group header. Display the result in the Group footer. Suppress the detail section.

Upvotes: 0

Related Questions