how to bind dataset in reporting table

• sharma.rishab90

  Grasshopper

  Points: 13

  More actions

  February 12, 2012 at 12:07 pm

  #251537

  hi,i am begineer to use ssrs

  i call a store procedure which returns a table having dynamic rows , i have to bind these rows in colums of report table???

  what expression i can use????????

  eg:

  amount1 sum net

  jan 1000 334 2622

  feb 344 564 454

  ...........

  ........

  output of report table should be like :

  jan feb mar april may june .......... ........ .........

  amount1 1000 344 ....

  sum 334 564 . ......

  net 2622 454

  please help me out...

  thanks

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  February 12, 2012 at 11:38 pm

  #1446099

  Create a matrix and drag all the fields from the dataset into the rows area of the matrix.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP