Need HELP on SSRS SPLIT function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Need HELP on SSRS SPLIT function

Need HELP on SSRS SPLIT function

Rate Topic

Display Mode

Topic Options

Author

Message

tinnusqlserver

Posted Friday, October 19, 2012 4:07 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 4:07 PM
Points: 38, Visits: 227

Hi All I need your advice,

1) I have a dynamic string which changes each time.

for example today the string will be "ItemA,ItemB,ItemC" and tomorrow it will be "itemA,ItemB" only.

2) I have an SSRS report which has 3 columns

3) I want to split this string "ItemA,ItemB,ItemC" and want to show splitted substrings in these 3 columns of ssrs table. the Delimiter is "," (comma)

4) I had used

=Split("ItemA,ItemB,ItemC",",").GetValue(0) in the first column of the report

=Split("ItemA,ItemB,ItemC",",").GetValue(1) in the second column of the report

=Split("ItemA,ItemB,ItemC",",").GetValue(2) in the third column of the report

5) everything works fine until my string is "ItemA,ItemB,ItemC" ,

BUT WHEN MY STRING CHANGES TO "ItemA,ItemB", then I am seeing "#Error" in the third column.

I understood the error, for

=Split("ItemA,ItemB,ItemC",",").GetValue(2) we dont have any value because the string now has only 2 values after applying split function

Is there any way i can avoid #Error in the third column.

NOTE: I have to compulsorily use 3 columns in the ssrs report.

I had tried using =Replace(Split("ItemA,ItemB",",").GetValue(2),"#Error","NULL") in the third column but that also wont worked.

Appreciate Your Help,

Raj Vardhan

Post #1375055

Daniel Forrester 123

Posted Thursday, November 29, 2012 4:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, March 04, 2013 6:23 AM
Points: 261, Visits: 167

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

Post #1390426

Steven.Howes

Posted Friday, November 30, 2012 7:10 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 370, Visits: 1,655

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.

Post #1391291

« Prev Topic | Next Topic »

Permissions