asked
Translate Case stmt into an expression
Hi All, Can someone help me how to translate this case stmt into an rdl expression in ssrs 2005. CASE WHEN ISNULL(C.TRIP_NO,B.TRIP_NO)=9999 OR LTRIM(RTRIM(C.SCHED_TIME))='' OR C.SCHED_TIME IS NULL THEN '' ELSE (CASE WHEN SUBSTRING(C.SCHED_TIME,1,2)>=24 THEN CAST((SUBSTRING(C.SCHED_TIME,1,2)-24) AS VARCHAR) + SUBSTRING(C.SCHED_TIME,3,6)+' AM' ELSE (CASE WHEN SUBSTRING(C.SCHED_TIME,1,2)>=12 THEN C.SCHED_TIME+' PM' ELSE C.SCHED_TIME+' AM'END) END) Cheers, swanky
You could nest a load of IIf statements, but it's going to end up unreadable I suspect. Personally, I would stick with using the case statements in the SQL that the report uses - is there a reason why that isn't possible?
Hi Thanks ! Yes ; it is having a huge impact on performace of my report.hence i would like to handle the same in rdl.i even tried but was prmpted with an error. here is the expression i have used. =iif(Fields!Trip_Number.Value=9999 or Isnothing(Fields!SCHED_TIME.Value),"", (iif(Cstr(left(Fields!SCHED_TIME.Value,2)).Contains(":"),formatdatetime(Fields!SCHED_TIME.Value,3), (iif(Left(Fields!SCHED_TIME.Value,2)>=24,(Cstr(Left(Fields!SCHED_TIME.Value,2)-24)+ Cstr(Right(Fields!SCHED_TIME.Value,6))+" AM"), formatdatetime(Fields!SCHED_TIME.Value,3))) ) ) ) Can someone tell me where i was wrong !
11 People are following this question.
