Report for assets on a contract
This is a report that will show you assets (resources) for a contract. You must use the query builder for this one, as you cannot make it in the wizard to my knowledge. Hopefully someone else finds this useful.
SELECT mcontract.CONTRACTNAME 'Contract Name',Model.udf_char7 'Model',resource.SERIALNO 'Serial Number',resource.ASSETTAG 'Asset Tag',resource.RESOURCENAME 'Resource Name' FROM contractdetails contractd LEFT JOIN MaintenanceContract mcontract ON contractd.CONTRACTID=mcontract.CONTRACTID LEFT JOIN Resources resource ON contractd.RESOURCEID=resource.RESOURCEID LEFT JOIN resource_fields Model ON resource.RESOURCEID=Model.RESOURCEID WHERE ( mcontract.CONTRACTNAME LIKE '%auniquebitofyourcontractname%') ORDER BY 1,2,3