I have a report where the Return Reason Description may wrap onto the next line. This happens when (and only when) the return reason description is longer than the character space provided on the initial line. Unfortunately, the Multiple Lines functionality within the Advanced tab appears to be map the second line directly underneath the existing data as opposed to moving horizontally. In other words, my second line is to the left not underneath my first line. As such, I have created two separate fields, hidden both fields, and then created a third calculated field which concatenates both fields. However, is there a way to import this field as a single field without the extra steps? Any assistance is appreciated!
Currently, this data is mapped as a Group Footer template as the data is underneath the record and may not exist for all records.