You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

concatenate data elements with line break in BI excel template

edited Mar 17, 2025 8:44AM in Reporting and Analytics for ERP 1 comment

Summary:

<?concat(.//SUPP_NAME,';',.//SUPP_NAME2,';',.//SUPP_NAME3)?> It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' .

In my case comma "," also displaying for null cases.

Hence i am trying to display with line breaks in the excel templates.

Below syntax didnt work:

<?concat(.//SUPP_NAME,chr(10),.//SUPP_NAME2,chr(10),.//SUPP_NAME3)?>

Please suggest

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!