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.