Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Band 'Detail' in Report Designer
Message
De
12/02/1999 16:14:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00184099
Message ID:
00187190
Vues:
22
Hello

Thank you for your advice, but I didn't explain my problem in-depth enough ...

Actually, I made report based on parametrized View. That View I created including Table "Person" with parameter Person.Num= ?nNum . For that view I create relation with Table1, Table2 on Fields:
Person.year+Person.month +Person.num to Table1.year+Table1.month+Table1.num
Person.year+Person.month +Person.num to Table2.year+Table2.month+Table2.num

Table2 has relation on fields Table2.code with Table3.code
Table2.code to Table3.code(so table3 doesn't have any related fields with table1)


Those relations I created in Report's DataEnvironment .
I succeeded to obtain for each records in Table Person matching records in Table1, Table2 and Table3 (just using relations).
In the Band "Detail" I put one Edit box for records in Table1,under this - Edit box for records in Table2

But records from Table3 I have to put under all the other in Band"Fouter".Doing so I get as a result just 1-st records in Table3 matching to records in Table2.
In order to get other records from Table3 I am trying in the Init method of the DataEnvironment to put those records in array using SQL command, but now problem is to show all elements from the array.

I am not sure this is the right way. I also try to create cursor just like you said, but this multiplies records in table"Person" as many times as i have records in two other tables,
so i can't get the rigth records in bamd"Detail" (they are much more).

Are you feeling tired ...?

Please help,
Galia
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform