Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does VFP9 Reports support grandchild tables?
Message
From
21/12/2006 16:04:01
 
 
To
20/12/2006 17:08:59
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01179329
Message ID:
01179679
Views:
8
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...

Albert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform