Matching report header/footer

[dduva]

I have six detail records that I want printed at the top of a report and the same six records I would like to repeat at the bottom of the report. In between these records I would like to print an entirely different set of detail records. Is this possible?

Is it possible to have mulitple detail bands? Or is it possible to have a footer mimic a header?

Thanks.

 

[cslawtom]

Place the six detail records in variables. Put the variables on the report.

 

[dduva]

How would I apply a specific record to a specific variable?

Specific fields to variables I understand, but how would I realate a whole record to a variable and then the next record to the next variable?

Thanks.

 

[ramani]

HI dduva,

***************************************************
1. In the header .. insert a field with expression GETMYHEADER()

2. Create a public myArray && create this before the report is run.

3. 2. Add a routine GETMYHEADER at right place of your code with following code.
COPY NEXT 6 TO ARRAY myArray && will copy six records

4. In your report use the array variables and print the report header and the footer.

Hope this idea works for you
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[dduva]

Thanks ramani. That was a good idea. Worked very well.