table to PIVOT report

jhanvincent14
jhanvincent14 Member Posts: 214
in NAV Three Tier
hello Everyone,

how do you handle a record and turn it into PIVOT format in Report? any tricks or sample ? btw, I'm still a beginner in C/AL. thanks in advance

Answers

  • logger
    logger Member Posts: 126
    Hi @jhanvincent14 ,
    What do you mean under PIVOT format in report? Can you show an example?
    Let's go!
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    hello @logger, appreciated your reply.

    I have a table/record and I need to pivot the data and show it in ssrs.
  • lubost
    lubost Member Posts: 633
    What do you mean "pivot the data"?
  • logger
    logger Member Posts: 126
    @jhanvincent14 , you mean you want to group data using some criterias?
    Let's go!
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    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
  • lubost
    lubost Member Posts: 633
    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.

Categories