How to print detail table twice on the same sheet

[mensud]

I have a table populated with some data grouped by "code" field. What I am trying to do is to print this table twice on the same sheet of paper. In report, I am using group band (field "code" from the table) and detail band. Is there any possibility to use detail band twice, or soemthing ...?

Thanks.

Mensud

 

[Mike Gagnon]

mensud
Is there any possibility to use detail band twice, or soemthing ...?


Faq184-1253


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[jimstarr]

Hi Mensud,

I'd do something like this:

SELECT *, '1' as seqno FROM mytable INTO CURSOR cursor1 READWRITE
INDEX ON mycode + seqno
SELECT *, '2' as seqno FROM mytable INTO CURSOR cursor2
SELECT cursor1
APPEND FROM DBF('cursor2')

cursor1 is now a doubled-up version of your original table.

Jim

 

[BPeisch]

Do you want to print exactly the same content in both tables? If so, you can just copy the contents of the table and paste it a second time in the detail band where you want it to print the second table.



-BP

http://www.peisch.com

 

[PaulColes]

At the end of the first table print call a function that returns "" and contains the code to go to the first record you with to print from.


=gotop()


function gotop
go top && or locate code
return ""

this will put the report in a never ending loop so some sort of switch needs to be incorporated.