Daniel Forrester 123
SSCrazy
Points: 2276
More actions
November 29, 2012 at 4:49 am
#1563673
Hi,
You could write a function using the embedded code option in SSRS. This would enable you to use better string manipulation functions and error handling in VB.
Regards
Daniel
Steven.Howes
SSCertifiable
Points: 6230
November 30, 2012 at 7:10 am
#1564351
What if you cheated and appended a few extra commas to your string so that it looked like:
"ItemA,ItemB,,,", or "ItemA,,,"
That way your split function would return a blank string.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply