none
ssrs 2008 r2 display values in one column for display purposes

    Question

  • 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 01, 2013 4:55 PM

Answers

  • 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 - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Friday, November 01, 2013 5:32 PM