Skip to Content
0
May 09, 2018 at 03:49 PM

Unwanted line break when exporting to text - Crystal Reports

2498 Views

Hello,

I am working on a data extract that requires a HL7 header be created. I am able to do this in a string field, but when exporting to text it creates a line break. I can't fit everything into a single line in the report and export it as once string is longer than 22.5 inches, it cuts out of the output completely.

Here is the line I am needing to export to text:
"MEMBER_SUBSCRIBER_ID|MEMBER_CTRL_NUM|MEMBER_FNAME|MEMBER_LNAME|MEMBER_SSN|MEDICARE_NUM|MEDICAID_NUM|BIRTHDATE|GND|PROVIDER_FNAME|PROVIDER_LNAME|PROVIDER_NPI|PROVIDERS_SPECIALTY|SERVICE_DATE|PLACE_OF_SERVICE|SERVICE_PERFORMED|SERVICE_RESULT|DIAGNOSIS1|DIAGNOSIS2|DIAGNOSIS3|DIAGNOSIS4|DIAGNOSIS5|DIAGNOSIS6|DIAGNOSIS7|DIAGNOSIS8|DIAGNOSIS9|DIAGNOSIS10|DIAGNOSIS11|DIAGNOSIS12|DIAGNOSIS13|DIAGNOSIS14|DIAGNOSIS15|DIAGNOSIS16|DIAGNOSIS17|DIAGNOSIS18|DIAGNOSIS19|DIAGNOSIS20|DIAGNOSIS21|DIAGNOSIS22|DIAGNOSIS23|DIAGNOSIS24|DIAGNOSIS25|ICD10_IND"

It ends up creating a line break at "DIAGNOSIS3". I have it set to lock size and position, and keep object together in the field. I have tried making it a text object and a formula field. I have also supressed blank sections when it was a text object. I have also tried the same settings in the header settings.

At this point I am unsure what to try. I do currently have the string put into a formula field, replacing line breaks in it. The report does have a sub report, but the sub report doesn't do anything with the header.

Does anyone have any tips or tricks I can try out on this?

Thanks,

Jonathan