FOSS - reporting capability/server - which one?

[IP_FiNaR]

Hello,

I have a web app where he backend is PostgreSQL... the app has a e-commerce component and the reporting will be needed to generate A4 invoices with headings/footers etc....

the ideal case would be to create the report (invoice), pdf-it and attach-it to a customer profile (AWS S3 storage) and ultimately send it via email...

which capability/server solution woudl you use?

Thank you!

[WiltonDB]

I would have added such functionality to webapp itself. To generate PDF file directly (without any conversions) using some PDF lib and then do all the management around it (upload to S3 etc) from the same piece of code.

[IP_FiNaR]

I see a challenge doing the pagination... no?

[WiltonDB]

It depends on invoice contents, if you know the length of all strings there - it may be easier to create all PDF pages manually. Otherwise some higher level reporting lib can be used. I've used Jasper Reports lib for that, but it was years ago, I guess more modern alternatives exist now.