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' , ' ' )