table to PIVOT report

jhanvincent14

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

logger

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

jhanvincent14

hello @logger, appreciated your reply.

I have a table/record and I need to pivot the data and show it in ssrs.

lubost

What do you mean "pivot the data"?

logger

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

jhanvincent14

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

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.