Converting Column values into Rows - RTF Template

Question

Summary

Content

Dear Friends,

I have a requirement in RTF Template to convert the column values into rows based on an Account_Number.

For example, Account_Number 001 has Year values as 2011, 2012, 2013, 2014, 2015, 2016.

As using the source as SQL Query, it comes to RTF template as like below.

Account_Number     Year

----------------------     ------

001                         2011

001                         2012

001                         2013

001                         2014

001                         2015

001                         2016

But the requirement is to display the value as below.

2011, 2012, 2013, 2014, 2015, 2016

I dont want to display the account number.

Please help me to achieve this, I stuck here for long time.

Any help would be appreciated.

Thanks.

nm.Mani · Answer

hi,

have you tried pivot option and hide the account column?

thanks

MM

Venkat Thota - BIP · Answer

best way is to do at sql query side ,if you can't do ,send me query with sample data.

or you can do at template level ,send me rtf and xml,will send you modified one.

Follow below link at template level

Matrix Report in BI Publisher

Thanks

http://apps2fusion.com/at/kr/345-matrix-cross-tab-report-bi-publisher