Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange problem with two detail bands
Message
De
23/03/2007 10:06:35
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Allemagne
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Divers
Thread ID:
01207539
Message ID:
01207635
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform