Informe agrupado / resumido

[joebordes]

He estado intentando hacer esto sin éxito.

Supongo que lo más fácil será lanzar directamente en mysql:

Code:

SELECT accountname as 'Accounts_accountname', concat(vtiger_invoice.currency_id,'::',sum(total)) as 'Invoice_Total',
vtiger_account.accountid as 'LBL_ACTION'
from vtiger_invoice
inner join vtiger_crmentity on crmid=vtiger_invoice.invoiceid
inner join vtiger_account on vtiger_invoice.accountid=vtiger_account.accountid
WHERE vtiger_invoice.invoiceid > 0 AND deleted=0
group by vtiger_invoice.accountid ,vtiger_invoice.currency_id
having sum(vtiger_invoice.total) >= 3000