Multiple Row From A Table To A Single Row in SSRS Report

• Subbu S

  Old Hand

  Points: 389

  More actions

  February 24, 2011 at 12:46 am

  #235451

  Hi I'm new to SSRS. I'm trying to publish a report that is easy to read, but I end up printing rows that are largely redundant. Consider the following tables:

  Table 1: Year; Model; Experince

  1988, Nearshore, 10

  1988, Onsite, 16

  1988, Offshore, 20

  1987, onsite, 30

  1987, offshore, 50

  1987, nearshore, 25

  I would like to get an output(SSRS) like

  Year Onsite Offshore Nearshore

  1987 30 50 25

  1988 16 20 10

  How to acheive this in SSRS, please guide me.

• jeffmtlca

  SSC Veteran

  Points: 207

  More actions

  February 24, 2011 at 8:28 am

  #1291022

  try matrix control in SSRS

• Subbu S

  Old Hand

  Points: 389

  More actions

  February 24, 2011 at 8:18 pm

  #1291348

  Hey thanx for your suggestion, i already tried that and got the output 🙂 🙂