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

Using decode function report is running forever

Started by jd, 31 May 2011 12:49:39 PM

Previous topic - Next topic

jd

Hi I have  one data item using decode function in my report like below:
when I pull this data item into my report, report is running forever.
any idea what is wrong in this one??

decode( (((((((((((((((((((((((((((((((((((([TLL_01]  || [TLL_02] ) || [TLL_03] ) || [TLL_04] ) || [TLL_05] ) || [TLL_06] ) || [TLL_07] ) || [TLL_08] ) || [TLL_09] ) || [TLL_010] ) || [TLL_011] ) || [TLL_012] ) || [TLL_013] ) || [TLL_014] ) || [TLL_015] ) || [TLL_016] ) || [TLL_017] ) || [TLL_018] ) || [TLL_019] ) || [TLL_020] ) || [TLL_021] ) || [TLL_022] ) || [TLL_023] ) || [TLL_024] ) || [TLL_025] ) || [TLL_026] ) || [TLL_027] ) || [TLL_028] ) || [TLL_029] ) || [TLL_030] ) || [TLL_031] ) || [TLL_032] ) || [TLL_033]) || [TLL_034] ) || [TLL_035] ) || [TLL_036] ) || [TLL_037] ), 'Y' , ' ' , 'Y'  )

For Ex: TLL_01 =   decode([FSC] ,'1210' , 'Y' , '1220' , 'Y' , '1240' , 'Y' , '1250' , 'Y' , '1260' , 'Y' , '1265' , 'Y' , ' '  )