Custom Report Query

How can I build a custom report with that query:

SELECT name, customer FROM tabOpportunity GROUP BY customer;

You can make a query report and just paste your query in.

I tried that, but when I click in “Show Report” button the report is empty.

You usually have to click the refresh button to reload the query.


Thank you.