In my next query I try to show some tags designed in crystal reports
.
How would you do that according to the AMOUNT of existence that a record has, that is to say if in Quantity = 2, two labels are generated?
This code is in the crystal file. I do not use any other language
SELECT e.numero, e.fechaemision, ei.cantidad, p.Codigo, p.descripcion
FROM entregas e
LEFT JOIN entregasitems ei ON e.RecID = ei.IDEntrega
left join productos p ON ei.IDProducto = p.RecID
WHERE e.RecID = '{?id}'