how to solve <br/> in logi report
Hello my friends,
I have a problem with logi report,
in my store procedure, I create code like this?
$ListToString(%DLIST(DISTINCT (ARCIM_Desc)),'<br/>') as "ARCIM_Desc", -> this is the problem
$ListToString(%DLIST(DISTINCT (MRDIA_ICDCode_DR)),'<br/>') as "MRDIA_ICDCode_DR", -> it's works fine
.png)
as you see there's a <br/> in the display of the report
I have no idea about this, maybe someone can help me fix this problem ?
Thank You
Best Regards,
Steven Henry
Comments
Hi Steven,
I started to take a look at this but haven't found an answer. There is documentation here that suggests Logi Report does support parsing and rendering HTML tags, but I'm not sure why it is inconsistent in your case. Is there some additional formatting in the values for ARCIM_Desc or MRDIA_ICDCode_DR that is causing Logi Report to parse HTML tags in one but not the other?
I looked into this a little more, and discussed it with a colleague. My understanding at this point is:
- Not all field types support HTML parsing/conversion
- For fields that do support HTML conversion, there should be properties called Convert HTML Tag (which should be set to true if you want to parse <br/> tags) and Ignore HTML Tag (which should be set to false) in the Text Format section of the field's properties in the Inspector pane
If you're still having trouble with this, please feel free to open a support case in IService so that TrakCare support can take a look at your report with you.
Details on $LISTTOSTRING
Your source seems to contain the <br/>
Try a different separator e.g. @ to verfiy it.
If it is in and you can see it, HTML tags < > might be escaped for some reason and not be
recognized but displayed as text instead
Possible workaround:
$ListToString(%DLIST(DISTINCT(REPLACE(ARCIM_Desc,'<br/>',''))),'<br/>') as"ARCIM_Desc",