ssrs 2008 r2 display values in one column for display purposes


  • In a SSRS 2008 report, I have a column where there a lots of values concatenated together. I want to split the field into several columns to be able to display the values on various parts of the SSRS report. This would be like a substring function in sql server. Can you tell me how to accomnplish this task in SSRS 2008 r2?
    Friday, November 1, 2013 4:55 PM


  • Hi ,

    Better idea is to split and form the data in SQL Server using T-SQL and then display it on report with Fields from Dataset .

    sathya - ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Friday, November 1, 2013 5:32 PM