Page 1 of 1

[Solved] Repeat fields on more than one page

Posted: Wed Sep 04, 2024 1:15 am
by dreamquartz
Hi All,

I am trying to produce a simple 2 page report where on the front and the back the same persons are listed.
The report is the same as inviewtopic.php?t=111803.
I need to be able to repeat the column "Surname, GivenName" and then print the report double sided.
This column can hold between 1 and 12 records.

I have scoured the interweb, but have come up empty.

Any guidance is appreciated.

Dream

Re: Repeat fields on more than one page

Posted: Wed Sep 04, 2024 4:17 pm
by Villeroy
to be stored in "direct SQL mode":

Code: Select all

SELECT <column list>, 1 AS "Page" FROM "Somewhere"
UNION ALL SELECT <column list>, 2 AS "Page" FROM "Somewhere"

Re: Repeat fields on more than one page

Posted: Wed Sep 25, 2024 5:25 pm
by dreamquartz
Thank you so much. that works great.