I am stuck in a situation here. Instead of getting a report in drill down vertical I need it in horizontal. e.g.- Comp Branch Date Revenue Company1 Office1 01/01 100 Company1 Office1 02/01 200 Company1 Office1 03/01 150 Company1 Office2 01/01 1000 Company1
Office2 02/01 500 Company1 Office2 03/01 2500 Company1 Office3 02/01 150 Company1 Office3 03/01 500 Company2 Office1 01/01 1000 Company2 Office2 02/01 100 Company2 Office3 03/01 250 Now I need to display this horizontally in crystal in the following format
It's coming messed up in formatting, but its basically all company names on left in a column, and then revenue of each office according to each month of the year, in one row Office1 Office2 01/01 02/01 03/01 01/01 02/01 03/01 ... Company1 100 200 150 1000
500 2500 .... Company2 ...... How do u do this in Crystal for all offices and all companies?..I hope i havent confused u
