--- reportDefinition: ! description: "InvoiceItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "PDF" templateName: "Invoice items with missing received dates" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "invoice.date" label: "Date" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Invoice items with missing received dates" querySpecification: specification: "matchEvery {\n invoice.date.between param(\"startDate\",\"\"\ ,\"Invoice Start Date\"),param(\"endDate\",\"\",\"Invoice End Date\")\n received.notNull()\ \ \n}" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.invoice.InvoiceItem" properties: ! - ! description: "PO #" type: "java.lang.Integer" propertyName: "number" propertyPath: "poChargeId.purchaseOrderId.purchaseOrder" entityName: "PurchaseOrder" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "PO #" columnTitle: "PO #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "poChargeId.purchaseOrderId.purchaseOrder.number" dataSourcePath: path: ! [] currentPath: ! - "poChargeId" - "purchaseOrderId" - "purchaseOrder" columnOrder: 1 suppressRepeating: false - ! description: "Invoice #" type: "java.lang.Integer" propertyName: "number" propertyPath: "invoice" entityName: "Invoice" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "Invoice #" columnTitle: "Invoice #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "invoice.number" dataSourcePath: path: ! [] currentPath: ! - "invoice" columnOrder: 2 suppressRepeating: false - ! description: "Line Number" type: "java.lang.Integer" propertyName: "lineNumber" propertyPath: null entityName: "InvoiceItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Item #" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "lineNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "invoice" entityName: "Invoice" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Invoice Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "invoice.date" dataSourcePath: path: ! [] currentPath: ! - "invoice" columnOrder: 4 suppressRepeating: false - ! description: "Received" type: "java.util.Calendar" propertyName: "received" propertyPath: null entityName: "InvoicePOItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Received Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "received" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false