SQL Server reporting services: How to use the Split function in the SSRS expressions to get sub-string?

Standard

Problem Statement:
How do you use SQL Server Reporting Services (SSRS) expression to get sub-string from the inputted text?

Solution:
I am going to show you few SSRS expressions that you can use in your SSRS reports:

SSRS SQL Server Reporting Services Expression SPLIT

Here’s the same in a text:

Input:SSRS Expression used:Output:
[Date].[Fiscal Year].&[2008]Split(Parameters!DateFiscalYear.Value,”&”)(1)[2008]
[Date].[Fiscal Year].&[2008]Split(Parameters!DateFiscalYear.Value, “.”)(2)&[2008]
[Date].[Fiscal Year].&[2008]Split(Split(Split(Parameters!DateFiscalYear.Value, “&”)(1),”[“)(1),”]”)(0)2008
[Date].[Fiscal Year].&[2008]Parameters!DateFiscalYear.Value.Split(“&”)(1)[2008]

Conclusion:
In this post, you saw how to use the split function in SQL Server Reporting Services (SSRS) expressions to get a sub-string.

One thought on “SQL Server reporting services: How to use the Split function in the SSRS expressions to get sub-string?

  1. Matias Corredera

    Hello, I am working on Microsoft Report Builder
    I need to show in my report a set of data that comes in a text string separated by “,” (comma)

    I have a field where what I need to separate comes from like this:
    data1, data2, data3
    and I need to show them in the report like this (in the same column)

    data1
    data2
    data3
    I mean leave a line for each item in the split.

    Split (Fields! Data.Value, “,”) (0)

    I have tried this, it only shows me the value of position 0.
    Could it be done somehow? thanks!

What do you think? Leave a comment below.