Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Does VFP9 Reports support grandchild tables?
Hi Everyone,
You can just respond to the question in the thread title. For a bit of an explanation (that might prompt a workaround), here is what the client wants.
Law firm...wants to print detail of a single client file. Here are the tables and their relationships:
MainTable: Plaintiff, heading detail (name, date of birth etc; used to print in header area)
--> ChildTable1: contacts on this file (multiple, related to main by File_ID)
--> ChildTable2: annuities purchased for plaintiff; multiple; related to MainTable by File_ID
-----> GrandChildTable1: who purchased each annuity (multiple litigants may have contributed to purchasing the annuity); related to ChildTable2 by Annuity_ID
Results so far: I can get the info to print but the GrandChildren print *after* all of the ChildTable2 records whereas I would like the info to "interleave" in between each annuity e.g. (showing just the annuities):
Annuity 1: Sun Life of Canada, Total Premium: $10,000.00
---> Crash Dummies Casualty Co, Contributed: $5,000.00
---> Total Wrecks Insurance Co., Contributed: $5,000.00
Annuity2: The Manufacturers Insurance Co., Total Premium: xxx.xx
etc.
It could be that I am not putting in the right "target alias" for that expression (I have tried several). I am currently putting in "GrandChildTable1".
Thanks for any help.
Albert Gostick
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement