If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

concat erroring in cognos 11

Started by krishdw85, Yesterday at 11:33:08 AM

Previous topic - Next topic

krishdw85

[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.

dougp

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.