Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does VFP9 Reports support grandchild tables?
Message
From
21/12/2006 17:57:34
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
21/12/2006 16:04:01
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01179329
Message ID:
01179695
Views:
12
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform