Unable to view columns with CLOB datatype

Database Support
, ,
#1

Hello Helical Team,

I am using Helical Insight 4.0 with SQL Server database. When I try to create a report with columns with datatype CLOB, I get incorrect values as compared with the values in the database. Why is this happening and how do I resolve it?

Thank You,
Netta.

#2

Hello Netta,

When the datatype of the column is CLOB, then we need to convert it into STRING datatype. For this, you need to create a custom column with the query in following format:

CAST([SchemaName].[DatabaseName].[TableName].[ColumnName] as VARCHAR(50)])

Generate the report by using these custom columns. The report will be created successfully. Please note that the table or view name should not have spaces.

Thank You,
Helical Insight.