Transpose rows to columns in Crystal Reports - Stack Overflow

admin•2025-04-16 16:21:42•questions•阅读2

I'm new to crystal reports 2020 and need help with getting some data from rows into columns. The r

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.

发布者：admin，转转请注明出处：http://www.yc00.com/questions/1744644757a4585549.html

Transpose rows to columns in Crystal ReportsStack Overflow