show data as columns

• sanp

  SSC Rookie

  Points: 25

  More actions

  October 27, 2010 at 4:23 pm

  #225573

  hi i am new to ssrs, i need to design a report where the data would be shown as columns not rows, how do i do that.

  eg of data

  topic

  rank2 count

  rank1 count

  math science history geography english

  3 2 4 2 1

  2 3 1 5 2

  any help would be great

  Thanks.

• Peter Rijs

  Hall of Fame

  Points: 3400

  More actions

  October 28, 2010 at 4:04 am

  #1243419

  you should use a matrix instead of a table in your report.

  put topic in Columns, add a row in the Data part, than put score1 and score2 in the 2 cells in the Data part

  Peter Rijs
  BI Consultant, The Netherlands