June 9, 2011 at 10:19 am
Need some assistance here. I'm converting some Crystal reports to SSRS and I ran into a snag. In one of my reports, I have the following Crystal formula:
if
LEN({View_Report_LABELS.case_number}) = 15
then
LEFT(RIGHT({View_Report_LABELS.case_number},9),2)
else
RIGHT({View_Report_LABELS.case_number},2)
I'm trying to translate this into SSRS, but having trouble with the syntax. Can anyone assist? Thank you.
June 9, 2011 at 10:30 am
Select
case
when LEN({View_Report_LABELS.case_number}) = 15
then LEFT(RIGHT({View_Report_LABELS.case_number},9),2)
else
RIGHT({View_Report_LABELS.case_number},2)
end
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 9, 2011 at 10:32 am
Awesome thanks. I've been creating too many reports lately, didnt think about making a case statement. Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply