Help on report

[Rumallen]

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

[#2]

@Rumallen 

Please define "...revenue for each month..." as compared to "...client rental amount...."