Print Open Items in Close Cash Report

SELECT  t.TICKETID,
        CONVERT(ExtractValue(CAST(tl.ATTRIBUTES AS BINARY),
                             "//entry[@key='product.name']") USING utf8) AS PRODUCT,
        tl.UNITS,
        FORMAT(tl.PRICE, 2) AS PRICE
FROM TICKETLINES tl
JOIN RECEIPTS r
  ON tl.TICKET = r.ID
 AND r.MONEY = ?
JOIN TICKETS t
  ON t.ID = tl.TICKET
WHERE tl.PRODUCT IS NULL
GROUP BY r.ID
ORDER BY r.DATENEW;

Save

<line></line>
        <line>
            <text align ="center" length="48">OPEN ITEMS</text>
        </line>
        <line>
            <text length="10">Receipt</text>
            <text length="23">Product</text>
            <text length="5">Units</text>
            <text align="right" length="10">Price</text>
        </line>
        <line>
            <text>------------------------------------------------</text>
        </line>
        #foreach ($line in $payments.getSQLResult().get(0))
        <line>
            <text length="10">${line.printValue(0)}</text>
            <text length="23">${line.printValue(1)}</text>
            <text length="5">${line.printValue(2)}</text>
            <text align ="right" length="10">${line.printValue(3)}</text>
        </line>
        #end
        <line>
            <text>------------------------------------------------</text>
        </line>