1 Reply Latest reply: Aug 10, 2011 8:17 AM by fac586 RSS

    APEX Report to balance a column of data over 3 columns

    417717
      I have an sql report that outputs a code and description e.g.

      1  Ape
      2  Boar
      3  Cat
      4  Dog
      5  Elephant
      6  Goat
      7  Hare
      8  Ibis
      9  Jackel
      10 Kangaroo
      11 Lion
      12 Mouse
      13 Numbat

      I need the following output where the number of records can change but I always want the values to fit into 3 evenly balanced columns e.g. Sorry about trying to line the columns up


      1  Ape      6  Goat    11  Lion
      2  Boar      7  Hare    12  Mouse
      3  Cat      8  Ibis    13  Numbat
      4  Dog      9  Jackel    
      5  Elephant      10  Kangaroo    

      What is the best way to do this in one APEX report. I've tried using 3 separate reports in columns 1,2,3 side by side with "no template" but I can't seem to centre the 3 reports and spread out the values evenly across the page.
      thanks in advance
      Paul P