Print Page - concat erroring in cognos 11

Title: concat erroring in cognos 11
Post by: krishdw85 on 06 May 2025 11:33:08 AM

[ECode (rv)] || ' - ' || [ThirdNum (id)] || CHR(10) || [EquiCd Desc (blv)] || CHR(10) || [Seriber (au)]

We are getting blank for majority rows in C11 whereas it is working fine in cognos 10.
Pl guide how to fix the yhis concat error in c11.

Title: Re: concat erroring in cognos 11
Post by: dougp on 06 May 2025 03:42:27 PM

So, same data available to both Cognos 10 and Cognos 11? Are you sure? If any of those 4 values is NULL, the output will be NULL -- in 10 or 11.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: krishdw85 on 06 May 2025 11:33:08 AM