[solved]Printer output - help

[oldfart]

Help please on printer output.
A long story ...
With the help of some people on here, I have nearly completed an application.
Using pfSense to control WiFi access for guests in an apartment complex.
Voucher data is exported from pfSense to a csv file.
My application converts the csv file to a sqlite database.
So that a certificate can be issued for x days and then not re-issued.
The guest is given a voucher with a certificate number, and the number of valid days.
I need to output the data to a label printer.
I have got all the bits working except how to output to printer.
The image shows how the label should look.
There are 3 variables to print alongside an image.
var1, var2 ..
Do I start with a paintbox, or some other method?
Thanks

[AlexTP]

http://scalabium.com/faq/dct0090.htm shows that the simple example is:

Code: Pascal  [Select][+][-]

1. with Printer do
2. begin
3.   BeginDoc;
4.   Canvas.Draw(X, Y, bmp);
5.   EndDoc;
6. end;

[korba812]

Do I start with a paintbox, or some other method?

Use LazReport:
https://wiki.lazarus.freepascal.org/LazReport_Documentation

[oldfart]

First 2 replies won't work, the text on the bitmap doesn't exist until the program has run
That's why I mentioned the variables.

[oldfart]

This image is what the original one looks like,the variables need to be overlaid

[oldfart]

Its very simple, you make a  master bitmap and when you are ready you create another bitmap from the master and then write your text to the secondary bitmap. From there you strecteDraw the secodanry bitmap to the printer canvas.

strecteDraw - ????

[loaded]

8 years ago, I had LDAP authentication done between Pfsense and Zimbra. In memory of those days;

[oldfart]

8 years ago, I had LDAP authentication done between Pfsense and Zimbra. In memory of those days;

Thanks - will have a look

[korba812]

You can do this in minutes using LazReport. I am attaching a sample project.

[oldfart]

You can do this in minutes using LazReport. I am attaching a sample project.

Thanks so much, will have a play

error: Unable to find component class TfrDesigner
can't get to the visual form to drop a TfrReport on it

[korba812]

It looks like you don't have lazreport package installed. You can install this package from menu "Package" -> "Install/Uninstall Packages..."

[oldfart]

It looks like you don't have lazreport package installed. You can install this package from menu "Package" -> "Install/Uninstall Packages..."

thanks .. just playing now

error when building .. project1.lpi(1,2) Fatal: Syntax error, "BEGIN" expected but "<" found
or
when loading from .lpi file, access violation in Lazarus

EDIT
removed Lazarus
Now runs, with Lazreport
Build what you sent .. error the project has no main source file - yet I'm looking at it

[korba812]

Sorry, I'm using a Lazarus trunk. I am sending a revised project.

[oldfart]

Sorry, I'm using a Lazarus trunk. I am sending a revised project.

Thanks for the help, really appreciated!
Got struck somewhere else, hence slow reply.

Will be asking for help if I can't resolve - it involves multiple sqlite SELECT statements
My code (exactly) carries the last result of the first query into all the results of the second query.

[oldfart]

Thanks for everyone's help
Got it all working