Electronic Reporting line break

(1) Share

Report

Posted on by bcbeats

I'm trying to validate line breaks that we entered into a report format. We used CHAR(10) & CHAR(13) - and also tried just CHAR(10). When I look at the output TXT file (UTF-8 no BOM) it looks normal. But I noticed Notepad is calling everything line 1 and column XXXX.

I ran the file through Notepad++ and it shows everything on a single line with no CR LF.

When I go to test the format and put text before and after it feeds right. I entered /TE/ & CHAR(10) & CHAR(13) & /ST/ and it returns TE ST on two lines (see below).

Is this fine? Or am I using the wrong kind of break? Is it the field settings?

I have the same question (0)

All responses (4)

Answers (0)

Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

You can refer to the following three old threads, the problem maybe wasn't line break itself but double quotation that had to be introduced in string in order to excel recognizes it as one cell. You achieved this with using CHAR(34) as "" at the beginning and in the end of string with Concatenate function. Or you can try to use the <br> for including line breaks and put it into double quotes.

Solved: Electronic reporting format designer - CSV line break (dynamics.com)

Solved: Electronic Reporting - Destination Email - email body is missing the line breaks I configured. How to fix? (dynamics.com)

Line break in Electronic Reporting (dynamics.com)

Best regards,

Kevin

Was this reply helpful? Yes No
Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Beaton,

Can you share more info on what is your file type on the format designer? Can you change the maximum length?

char(13) is carriage return and char(10) is line feed, what is binding that you have created for the field? Do you just using Char(13)&Char(10)? Do you use them in combination with other formular like

"Invoice Id="& model.InvoiceBase.Id &CHAR(10)&

"Amount="& TEXT(model.InvoiceBase.Amount)

or Concatenate function.

Was this reply helpful? Yes No
bcbeats 48 on at

Like (0)

Report

Hi all, this is an issue. Even though it reads.correctly in notepad it doesn't keep the carriage return/line feed. This is for a positive pay file.

The file type is TXT (UTF-8 with no BOM). Also tried UTF-8 and still had the same result. I tried CHAR(13)&CHAR(10), and each on their own. <br> is for html so I don't think it works here.

I made sure that special characters line break is on for MainSequence. But unlike the case referenced I can't seem to unmap MainSequence without losing transactions. If I only have Transactions mapped to model.PositivePayTransactions then I only get the first transaction.

I also have a Header group in mine. It doesn't break either unless I add the special characters to Transactions. When I do that I get a break after the header, then breaks on every field in Transactions rather than after each transaction.

Ideas?

Was this reply helpful? Yes No
Suggested answer

bcbeats 48 on at

Like (0)

Report

I found the issue. The CR LF was getting cut off by the max sequence length in both the header and MainSequence. Added some allowed length and it's fine.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Electronic Reporting line break

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Electronic Reporting line break

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates