admin管理员组

文章数量:1390642

I'm new to crystal reports 2020 and need help with getting some data from rows into columns. The report will be exported into excel. Here is an example of the data right out of the table.

ActionID    TranID  FinDept Total Percentage
544            5    F551300   60
544            4    F554000   20
544            3    F556501   20
366            1    F551016   50
254            6    F551052   20
366            2    F555462   50
254            7    FF55001   80

The outcome I want to accomplish is this:

ActionID    FinDept1    Total Percentage1   FinDept2    Total Percentage2   FinDept3    Total Percentage3
544         F556501      20                 F554000     20                  F551300      60
366         F551016      50                 F555462     50      
254         F551052      20                 FF55001     80

Any help would be greatly appreciated.

本文标签： Transpose rows to columns in Crystal ReportsStack Overflow

版权声明：本文标题：Transpose rows to columns in Crystal Reports - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744644757a2617333.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。