SQL Reporting Services 2008 Spiting String

Posted by beakersoft | Posted in SQL Reporting Services | Posted on 28-04-2012

0


Just a quick post about splitting strings in reporting services. I had a need today to split up an address into number/street/town that was held in one filed instead of the separate ones. I found a couple of things online about how to do it, but they did’nt seem to work on SQL 2008, so here is the solution:

=Split(Fields!Address.Value, ” “).GetValue(0)

The split function returns an array, so all we are doing here is splitting the address filed up based on a space, and then returning the first item from the array. In my case this was the house number,

Write a comment

Comments links could be nofollow free.