Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
1 to many reporting problems.
Message
De
15/02/2001 14:09:35
 
 
À
15/02/2001 13:11:54
Jim Harty
FL Dept Fin Services-Div of Rehab & Liq
Tallahassee, Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00476378
Message ID:
00476415
Vues:
27
Are you expecting a detail line for each record in each child table??
In the past when I need that I have had to do a SELECT with a few JOINS to get what I want. I have a VFP programmer help file on my web site that has some info on the subject.

http://www.semo.net/suburb/thornton/visual.html

Enjoy

>i needed to rephrase the problem we are having.. we have a parent table with several (3) related child tables. the report has a group defined for the parent data, and the child data items are all located in the detail section of the report. we refer to all the report elements by table.field reference..we have used the set relation to & the set skip to, into each of the child tables, but when previewing the report, only the 1st record from each child table is appearing on report.. it appears that we are not cycling thru all the child records, as we have more that 1 in each child table, but only 1 parent record.
>
>we have all the tables set in the data environment, with a relation set, using our compound key.. alltr(key1)+alltr(key_year1).. if we remove the 2 item of the key in the relation & link only to the key1 item using another index, then we get all the records from the child table..but we need to use the secondary key (which is year).
>
>is there a subreport capability, which allows us to process thru the child records, or is there something we are missing in our setup ???
>
>jah
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform