

Second is an external script using pdfTK to overlay the current pdf with several background pages.Ĭonsidering Base I would either use my second approach or just copy the report, change colour in the second and print one after the other by macro. One is a macro in a Calc-Sheet, wich saves as pdf, then prints 2-3 times and changing background colour of the cells between prints (only on right side to save ink). The easier approach is to repeat the report. I don't know if it's possible for a database report to create one copy in color and one in black and white. A database solution will be superior to anything which you would improvise in Writer or Calc, and probably won't require any macros.īoard index » Getting started » Tutorials » Base I think the layout could include a header with a logo. Base can generate reports from the queries using a layout which you specify. You will access it using Base where you can create queries to select data from the tables then filter, summarize, sort, and/or group it. The data will be stored in database tables. However, a database will assign numbers automatically when the data is entered on the form which you've created for your invoice. The obvious search term would be invoice. You could search the forum to see if anyone has already done this. Expect to spend a week or more creating your first macro, more if you're not already a programmer.

You would need to develop a macro system to add that capability. Writer has no place to store or retrieve the last-used invoice number so that a template can display the next one. Would like to have invoice numbers automatically entered when opening template.
