Hi,
i have a query:
product_1 | green | 3,5€ | 12
product_2 | green | 4,5€ | 1
product_3 | black | 5€ | 14
product_4 | white | 3€ | 5
and i want to print informations for each product x times (x pages looked the same). And value x is in the last column. Is it possible in Libreoffice Base/reports? Thanks for any help.
[Solved] Print the same page x times (x from query)
[Solved] Print the same page x times (x from query)
Last edited by mihmih on Mon May 02, 2016 12:39 pm, edited 1 time in total.
LibreOffice 4.2 on Windows7
Re: print the same page x times (x from query)
Easy method but a little bit clumsy:
Open a spreadsheet, create a sequence 1 to X where X is the max. number you expect.
Insert a field name on top of the column.
Copy the sequence (with field name) as a new table into your database. The field type should be integer.
combines each record of "YourQuery" with all sequence values where the x number is smaller than or equal to the sequence.
Open a spreadsheet, create a sequence 1 to X where X is the max. number you expect.
Insert a field name on top of the column.
Copy the sequence (with field name) as a new table into your database. The field type should be integer.
Code: Select all
SELECT "YourQuery".* FROM "YourQuery" JOIN "Sequence" ON "YourQuery."X"<="Sequence"."X"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Print the same page x times (x from query)
thank you very much, it works.
for future visitors: (comparison sign)
for future visitors: (comparison sign)
Code: Select all
...ON "YourQuery."X">="Sequence"."X"
LibreOffice 4.2 on Windows7