Category
Report Builder
Product Version
7.3
CLOB Line Breaks in Data
Answered
Using Smart Reporting - we have a database CLOB field which has line breaks but this is not getting translated across to the report table in Smart Reporting. Instead everything is getting mapped to a wall of text.
Is there a way to fix this / introduce a line break?
The same question
Hi Brijesh,
Line breaks and other escape characters will not appear within a report's table. However, these characters are still present, so alternative display will be your best option.
One thing worth trying here is to use the "HTML" or "Raw" formatters:
Let me know if this works for you.
Nathan
Hi Brijesh,
Line breaks and other escape characters will not appear within a report's table. However, these characters are still present, so alternative display will be your best option.
One thing worth trying here is to use the "HTML" or "Raw" formatters:
Let me know if this works for you.
Nathan
Hi Nathan,
Unfortunately it did not. Is there a “replace string” feature that could be utilised? Could potentially use this to replace a string of characters (“---------“) with a visual line break?
Kind Regards,
Brijesh
Brijesh Patel
ITSM Consultant
M: +44 7496 106 961
www.FusionGBS.com
This email messages and accompanying data are for the sole use of the intended recipient('s) and may contain information that is confidential. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this email message in error, please notify us immediately at https://www.fusiongbs.com/contact-us/ and erase all copies of this message and attachments. Please note that Fusion Business Solutions monitors incoming and outgoing mail for compliance with its Security Policy. This will include scanning incoming emails to detect viruses and archiving all email correspondence. Fusion Business Solutions (UK) LTD registered in England and Wales (company number 03508523). Our registered office is at: 2 Clarendon Road, Ashford, Middlesex, TW15 2QE. Switchboard: +44 20 8814 4888 FAX: +44 20 8570 8240 From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: 31 October 2017 20:00
To: Brijesh Patel <brijesh.patel@fusiongbs.com>
Subject: New Comment in "CLOB Line Breaks in Data"
Hi Nathan,
Unfortunately it did not. Is there a “replace string” feature that could be utilised? Could potentially use this to replace a string of characters (“---------“) with a visual line break?
Kind Regards,
Brijesh
Brijesh Patel
ITSM Consultant
M: +44 7496 106 961
www.FusionGBS.com
This email messages and accompanying data are for the sole use of the intended recipient('s) and may contain information that is confidential. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this email message in error, please notify us immediately at https://www.fusiongbs.com/contact-us/ and erase all copies of this message and attachments. Please note that Fusion Business Solutions monitors incoming and outgoing mail for compliance with its Security Policy. This will include scanning incoming emails to detect viruses and archiving all email correspondence. Fusion Business Solutions (UK) LTD registered in England and Wales (company number 03508523). Our registered office is at: 2 Clarendon Road, Ashford, Middlesex, TW15 2QE. Switchboard: +44 20 8814 4888 FAX: +44 20 8570 8240 From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: 31 October 2017 20:00
To: Brijesh Patel <brijesh.patel@fusiongbs.com>
Subject: New Comment in "CLOB Line Breaks in Data"
Hi Brijesh,
Not built into the product, so this would probably need to be done with a freehand-SQL statement.
Regards,
Nathan
Hi Brijesh,
Not built into the product, so this would probably need to be done with a freehand-SQL statement.
Regards,
Nathan
Ok thanks Nathan.
Kind Regards,
Brijesh
Brijesh Patel
ITSM Consultant
M: +44 7496 106 961
www.FusionGBS.com
This email messages and accompanying data are for the sole use of the intended recipient('s) and may contain information that is confidential. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this email message in error, please notify us immediately at https://www.fusiongbs.com/contact-us/ and erase all copies of this message and attachments. Please note that Fusion Business Solutions monitors incoming and outgoing mail for compliance with its Security Policy. This will include scanning incoming emails to detect viruses and archiving all email correspondence. Fusion Business Solutions (UK) LTD registered in England and Wales (company number 03508523). Our registered office is at: 2 Clarendon Road, Ashford, Middlesex, TW15 2QE. Switchboard: +44 20 8814 4888 FAX: +44 20 8570 8240 From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: 01 November 2017 15:30
To: Brijesh Patel <brijesh.patel@fusiongbs.com>
Subject: New Comment in "CLOB Line Breaks in Data"
Ok thanks Nathan.
Kind Regards,
Brijesh
Brijesh Patel
ITSM Consultant
M: +44 7496 106 961
www.FusionGBS.com
This email messages and accompanying data are for the sole use of the intended recipient('s) and may contain information that is confidential. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this email message in error, please notify us immediately at https://www.fusiongbs.com/contact-us/ and erase all copies of this message and attachments. Please note that Fusion Business Solutions monitors incoming and outgoing mail for compliance with its Security Policy. This will include scanning incoming emails to detect viruses and archiving all email correspondence. Fusion Business Solutions (UK) LTD registered in England and Wales (company number 03508523). Our registered office is at: 2 Clarendon Road, Ashford, Middlesex, TW15 2QE. Switchboard: +44 20 8814 4888 FAX: +44 20 8570 8240 From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: 01 November 2017 15:30
To: Brijesh Patel <brijesh.patel@fusiongbs.com>
Subject: New Comment in "CLOB Line Breaks in Data"
Hi Brijesh,
No worries, I am going to close this case but let me know if you have any more questions.
Regards,
Nathan
Hi Brijesh,
No worries, I am going to close this case but let me know if you have any more questions.
Regards,
Nathan
Replies have been locked on this page!