Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to convert column data into row data in crystal report?


Your help is very much appreciated.

I have a report with 3 colmns as follows,

User id Description LVL

Test1 Menu1 2

Test1 Menu2 4

Test1 Menu3 5

Test2 Menu1 3

Test2 Menu2 2 .......

I want the above data ib the following format,

User id | Menu1 | Menu2| Menu3

Test1 | 2 | 4 | 5

Test2 | 3 | 2|

How can this be achieved in crystal report?

Please let me know the solution if you can find one.


Former Member

You should create formulas on this but you should not use them in record selection.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question