Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does VFP9 Reports support grandchild tables?
Message
De
21/12/2006 17:57:34
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
21/12/2006 16:04:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01179329
Message ID:
01179695
Vues:
13
>Hi Craig,
>
>Got a fair bit of it working...I have hit a bit of a snag though in that trying to suppress the repeated values won't give me what I need. Data should look something like this for one of the child tables.
>
>(App #1)
>Sun Life Premium: $800,000.00 Date: Dec 15/06
> (indent) CasualtyCo1_Name Funded: $400,000.00
>Sun Life Premium: $800,000.00 Date: Dec 15/06 (<-- suppress this info)
> (indent) CasualtyCo2_Name Funded: $400,000.00
>
>(App #2)
>Sun Life Premium: $250,000.00 Date: Dec 15/06
> (indent) CasualtyCo3_Name Funded: $100,000.00
>Sun Life Premium: $250,000.00 Date: Dec 15/06 (<-- suppress this info)
> (indent) CasualtyCo3_Name Funded: $150,000.00
>
>So you see I cannot just put a "supress repeated values" because sometimes the info repeats and I want it to print and sometimes not. Normally I would have grouped on App_ID and had the info print when the App_ID changes. But it seems like grouping only applies to the primary (driving) cursor.
>
>I wonder if I have to somehow set some flag var to track when I have changed App_ID's within the child grouping and use that in the print when...

You can. You need to set a report variable, say lnAppId. You can then evaluate _vfp.DoCmd("lnAppId=apps.appnumber") in group header, then use lnAppId=apps.appnumber as your PrintWhen expression. Or choose any other good time to set this variable.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform