General information
Category:
Reports & Report designer
Title:
? Printing 3 Records
I have a situation where I am trying to emulate a printed
form. Due to the shear volume of data and the way the
ten page report is layed out, I can not use the detail band.
I am going down the route of placing all table fields in
the report page header. My problem occurs when I would like
to SKIP to the next record in a view - the other fields are
not showing.
To emulate the process, create a table with two
fields as follows:
CREATE CURSOR ctest (c1 c(3), n1 n(1))
FOR lni = 1 TO 3
m.c1 = CHR(64 + lni) && A, B, C
m.n1 = lni
INSERT INTO ctest FROM MEMVAR
NEXT
In the page header of a report named test I simply have two fields c1 and n1. However I do repeat a copy of these fields 2 times
to in essence show 3 lines in the page header.
I then want to do the following:
REPORT FORM test NEXT 1
I tried to put a function call on the N1 format to call a UDF to
SKIP 1 in the table. However this does not work.
It is imparative that I only show the first record in the real report.
The test scenario is simply to convey the concept.
Anyone know how to solve this problem? I really need to
show all 3 values without using the detail band. How can
I skip and then show the next record?
I
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only