I need to add a new report to my SugarCRM and I do not know how to do it. I have SugarCRM On-Demand version. (So I can not touch PHP code or execute SQL Queries into the database)

I need a simple report that gives me all Leads without calls where status=planned, I think the SQL Query could be something like this:

SELECT * FROM leads
LEFT JOIN calls_leads l1_1 ON leads.id=l1_1.lead_id AND l1_1.deleted=0
LEFT JOIN calls l1 ON l1.id=l1_1.call_id AND l1.deleted=0 AND leads.status IN ('Planned')
WHERE l1.id IS NULL

But I do not know how to do this in SugarCRM Professional On-Demand version. Is it possible?

Thanks, Andres Rormoser
Test Psicométrico PDA