farmat of the report out put

Hi,i am having a requirement to get the out put in below format

supplier      po_number          item              quantity            price                      totam po amount
xxxsupplier     1001                     as54888              10                       25                              250
                                                     as54999              5                         50                              250
                                                     1001                   20                        10                             200

The actual data which i am getting from the select statement is like below
supplier      po_number          item              quantity            price                      totam po amount
xxxsupplier       1001                 as54888              10                       25                              250
xxxsupplier     1001                   as54999              5                         50                               250
xxxsupplier     1001                   1001                   20                         10                             200


can you please respond me immediately i need to deliver the component today

it can be achieved by using the grouping but the lay out creation is some what difficult and the mean time it does not look good


Regards
-------------
Ripendra