Friday, 29 June 2012

SSRS Report: Switch case


=switch(
Fields!BoxNumber.Value <=6, "Mon" & Fields!BoxNumber.Value,
Fields!BoxNumber.Value <=12, "Tue" & Fields!BoxNumber.Value mod 7 +1,
Fields!BoxNumber.Value <=18, "Wed" & Fields!BoxNumber.Value mod 13 +1,
Fields!BoxNumber.Value <=24, "Thu" & Fields!BoxNumber.Value mod 19 +1,
Fields!BoxNumber.Value <=30, "Fri" & Fields!BoxNumber.Value mod 25 +1
)

No comments:

Post a Comment