table to PIVOT report

Answers

• Options

  logger Member Posts: 126

  2017-12-12

  Hi @jhanvincent14 ,
  What do you mean under PIVOT format in report? Can you show an example?

  Let's go!
  

  0
• Options

  jhanvincent14 Member Posts: 214

  2017-12-13

  hello @logger, appreciated your reply.
  
  I have a table/record and I need to pivot the data and show it in ssrs.

  0
• Options

  lubost Member Posts: 615

  2017-12-13

  What do you mean "pivot the data"?

  0
• Options

  logger Member Posts: 126

  2017-12-13

  @jhanvincent14 , you mean you want to group data using some criterias?

  Let's go!
  

  0
• Options

  jhanvincent14 Member Posts: 214

  2017-12-13

  basically, I want to make the rows of the table to be the column in the report and the column of the table will be the row of the report

  0
• Options

  lubost Member Posts: 615

  2017-12-13

  It seems to be a not very good idea (because unbounded number of rows). But you can use an array to store values and loop the array in Integer dataitem.

  1