Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
? Printing 3 Records
Message
From
28/02/1998 16:15:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
? Printing 3 Records
Miscellaneous
Thread ID:
00081906
Message ID:
00081906
Views:
50
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
Map
View

Click here to load this message in the networking platform