rows to columns in a report

• harita

  SSCrazy

  Points: 2197

  More actions

  September 30, 2010 at 9:19 pm

  #227229

  how to convert the input from row to columns

  12345678

  as

  1

  2

  3

  4

  5

  6

  7

  8

  and vice verse in building a report

• H4K

  Hall of Fame

  Points: 3374

  More actions

  October 3, 2010 at 6:24 am

  #1230767

  then a simple mid function as shown below in SSRS can do this

  if and only if the number doesn't contain 1 as well as 2 digit no.

  =mid(Fields!SrNo.Value,rownumber(nothing),1)

  i.e., 1234567891011121314 can be splitted into

  1

  2

  3

  4

  5

  6

  7

  8

  9

  1

  0

  1

  1

  1

  2

  1

  3

  1

  4

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  October 6, 2010 at 11:52 pm

  #1233263

  If the input is delimitted string then you can use below function

  Function to Split Multi-valued Parameters

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers