Contract Report Issue

Contract Report Issue

I am trying to run a seemingly simple report in Asset Explorer. I am just trying to run a report that that shows my current contracts organized by their departments. The problem is that when i run the report I get 3 separate totals for the same department.  My department field is coded correctly on each contract but for some reason i have 3 IT Departments on this report even though I should just have one. I have attached the report for review. 

SQL statement- 
SELECT cadf.UDF_CHAR1 AS "Department", cadf.UDF_CHAR1 AS "Department", mcdt.CONTRACTNAME AS "Contract Name", aao.NAME AS "Maintenance Vendor Name", longtodate(mcdt.FROMDATE) AS "From Date", longtodate(mcdt.TODATE) AS "To Date", cst.STATUSNAME AS "Contract Status" FROM MaintenanceContract mcdt LEFT JOIN Contract_Fields cadf ON mcdt.CONTRACTID=cadf.CONTRACTID LEFT JOIN VendorDefinition vdn ON mcdt.MAINTENANCEVENDOR=vdn.VENDORID LEFT JOIN SDOrganization aao ON vdn.VENDORID=aao.ORG_ID LEFT JOIN ContractStatus cst ON mcdt.STATUSID=cst.STATUSID ORDER BY 1 NULLS FIRST , 3 NULLS FIRST 


Thank you! 
              New to ADManager Plus?

                New to ADSelfService Plus?