pacoomu

Hi all, I have designed a report with a custom size page (widht: 209,903 mm; height: 136,525 mm) and it is used for printing on a matrix printer (Epson LQ-590). The problem is I can't specify the correct height of the page that must be 140mm, because the printer advances paper (at the end of the report) about 20mm more than when the height is specified to 136mm. I hope I have explained correctly, but my English is not good.

Hello, I think the best way to resolve this problem is to create a table with month names and numbers, and join it. Something like this: SELECT table1.field1, table1.field2, months.name FROM table1 LEFT JOIN months on months.id=month(date)