locked
Crystal Report Show in Horizontal Format RRS feed

  • Question

  • 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
    Tuesday, May 17, 2011 9:39 AM

Answers

  • Hello,

    It's not clear because your formatting is sequencial but Only way I could see this is to use a cross tab report.

    Don


    Don Williams
    Tuesday, May 17, 2011 11:56 PM