Real grouping of report rows

Real grouping of report rows

I'm trying to create a simple summary report and I need to be able to group rows like I would in any SQL database. It seems that Zoho CRM Reports has a group feature but it doesn't collapse the rows - I still get all the rows even though I only want the summary data.

Specifically, I want to create Companies report that shows me a distinct name of the company from the Lead and the number of leads we have for it. Something like "select company_name, count(*) as leads from lead group by company_name".

How do I do this?