Custom Report Query

[Leonardo_Augusto]

How can I build a custom report with that query:

SELECT name, customer FROM tabOpportunity GROUP BY customer;

[mslake]

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

[Leonardo_Augusto]

@mslake

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.

[mslake]

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

[Leonardo_Augusto]

@mslake

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

Worked!
Thank you.