Classic form customization EpiTextBox to Kinetic Application Studio Erp-Text-Area displaying garbage instead of line feed, carriage return

Classic form customization EpiTextBox to Kinetic Application Studio Erp-Text-Area displaying garbage instead of line feed, carriage return

Below are screen shots showing my issue.

Please help!

Thanks,
Richard

Classic text box definiton

Classic text box display data

Kinetic Application Studio text box definition

Kinetic Application Studio text box display data

1 Like

Did you try using the rich text contol?

3 Likes

Thank you for your Reply.

I tried the Rich Text idea and it returned an empty box where line feeds are instead of the box with an X in it.

Anymore ideas?

Thanks,
Richard

what is the actual data in that field, if you select it with a baq?

2 Likes

Thank you for you reply Alisa. Here is the baq results.

And if you put that in notepad to see the symbols?

I use clipboard viewer to see the actual characters (and codes).  
Like the following shows the text I copied ends with 
<CR><LF><sp><sp><sp><TAB><sp><CR><LF>

You might need CR and LF (and in a specific order) to show up like you want.

1 Like

May not be a solution to this one yet…
Application Studio: Line break from BAQ? - Kinetic ERP - Epicor User Help Forum

In my SysTasks dashboard, I have an erp-text-area that i am populating from a BAQ, with a calculated field that includes line breaks. All working well using CHAR(13) + CHAR(10):

	(CAST(STRING_AGG(SysTaskParam.ParamName + ': ' + 
        (CASE SysTaskParam.ParamDataType
            WHEN 'String'   THEN SysTaskParam.ParamCharacter
            WHEN 'Character'   THEN SysTaskParam.ParamCharacter
            WHEN 'Int32'    THEN CAST(SysTaskParam.ParamInteger  AS NVARCHAR(MAX))
            WHEN 'Boolean'  THEN CAST(SysTaskParam.ParamLogical  AS NVARCHAR(MAX))
            WHEN 'DateTime'     THEN FORMAT(SysTaskParam.ParamDate, 'yyyy-MM-dd hh:mm:ss tt')
            WHEN 'Decimal'  THEN CAST(SysTaskParam.ParamDecimal  AS NVARCHAR(MAX))
            WHEN 'Long'  THEN CAST(SysTaskParam.ParamLong  AS NVARCHAR(MAX))
            WHEN 'Token'    THEN SysTaskParam.ParamToken
            WHEN ''   THEN SysTaskParam.ParamCharacter
            ELSE 'No ParamDataType - could not display data'
        END)
, CHAR(13) + CHAR(10) ) AS NVARCHAR(MAX))) as [Calculated_Params] 

2 Likes