Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
help with report sql
#1
I need create a sql report, and try this command


SELECT sum( vtiger_cobropago.amount) as 'Soma Valor', sum(vtiger_cobropago.cost) as 'Soma Custos' , sum(vtiger_cobropago.benefit) as 'Soma Liquido',
COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname)
FROM vtiger_cobropago INNER JOIN vtiger_crmentity ON vtiger_cobropago.cobropagoid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid WHERE vtiger_crmentity.deleted=0 AND (( vtiger_crmentity.modifiedtime BETWEEN '2020-01-01 00:00:00' AND '2020-01-31 23:59:59') AND (( vtiger_cobropago.paid = '1') )) AND vtiger_cobropago.cobropagoid > 0 group BY COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname)


Working in sql directly command, in mySQL but in SQL reports, not

I think problem is with a user name

How i can solved that?

Thanks!
Ranieri
eCRM Web
Reply


Messages In This Thread
help with report sql - rslemer - 01-29-2020, 09:44 PM
RE: help with report sql - joebordes - 01-29-2020, 10:15 PM
RE: help with report sql - rslemer - 01-29-2020, 10:35 PM
RE: help with report sql - rslemer - 01-30-2020, 12:22 AM
RE: help with report sql - joebordes - 01-30-2020, 08:56 AM
RE: help with report sql - rslemer - 01-30-2020, 03:08 PM
RE: help with report sql - joebordes - 01-31-2020, 12:30 AM
RE: help with report sql - rslemer - 01-31-2020, 11:53 AM
RE: help with report sql - joebordes - 01-31-2020, 12:07 PM
RE: help with report sql - rslemer - 01-31-2020, 12:19 PM
RE: help with report sql - joebordes - 02-02-2020, 10:46 PM
RE: help with report sql - rslemer - 02-03-2020, 11:49 AM
RE: help with report sql - rslemer - 03-03-2020, 12:57 AM
RE: help with report sql - joebordes - 03-03-2020, 05:44 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)