How to Customize the Asset Register Report to remove special characters from asset description
I have to update the Data model query for Asset Register Report as the report is reading the special characters in asset description and resulting in distorted format of report output.
I have used the Q_Asset data set and updated the Description column as - REGEXP_REPLACE(AD2.DESCRIPTION,'[^-0-9A-Za-z |:*,.&$äöüÄÖÜßæøåÆØÅóÓ]','_') DESCRIPTION
in all the three unions.
But upon running the report from schedule process I am getting Error status with no details in the log.
I need help with this.
Thanks,
Shikha Singh
Tagged:
0