Help on report

Hi All.

I am in need of help with a report. I need to report on client rental amount and the revenue generated by the client. My query pulls this data fine (line by line), however I need  to report the client rental amount in a row and the revenue for each month in a separate column. How do I go about doing this?

Any advice would be greatly appreciated.

Thanks

R