Displaying nvarchar(max) column value in BIP report
Hi.
We have requirement to display value from nvarchar(max) column in BIP report. On DataSource level BIP treats this type of column as CLOB. In report designer during design time i can see the values, but in final report i see {xdo.clob} value instead. So far, as workaround i convert this column to nvarchar(4000) in select, but this will truncate some of the longest entries. Is there any other solution ?
We have requirement to display value from nvarchar(max) column in BIP report. On DataSource level BIP treats this type of column as CLOB. In report designer during design time i can see the values, but in final report i see {xdo.clob} value instead. So far, as workaround i convert this column to nvarchar(4000) in select, but this will truncate some of the longest entries. Is there any other solution ?
We are using
BIP 11.1.1.7.0
SQL Server 2005
0