Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange problem with two detail bands
Message
From
23/03/2007 10:06:35
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01207539
Message ID:
01207635
Views:
18
Hello Cathy

I want to print something like a shift scheduler
I have 3 cursors
a) Leading cursor "revier" only 1 record to columns "rbrevierid" + "revierbezeich"
used for printing title
b) Cursor "legende" for detail band1 (14 records all with rbrevierid, + some data)
used for explaining the abbreviations used in cursor listwahl
c) Cursor "listwahl" for detail band2 (12 records all with rbrevierid, + a lot of abbreviations and tags)

Befor starting the report i do
SELECT "listwahl"
INDEX on rbrevierid to SYS(2023) + "\LIRBREVID"

SELECT distinct rbrevierid,text,kuerzel,farbe,vorfarbe ;
FROM alledaten INTO CURSOR legende readwrite
SELECT "legende"
INDEX on rbrevierid to SYS(2023) + "\LERBREVID"

SELECT distinct rbrevierid,revierbezeich FROM arbeitspositionen ;
INTO CURSOR revier
INDEX on rbrevierid TO SYS(2023) + "\REREVID"

SELECT "revier"
SET RELATION TO rbrevierid INTO legende,rbrevierid INTO listwahl

I have to print 14 abbreviations in the legend because they are used in the 12 listwahl records
I get only 12 on the paper !??

Best regards
Albert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform