Christopher,
BTW, if you put "pre" and "/pre" tags around your example, it lines up nicely in the display! This is what I did.)
I see why you download the parent and child records separately. You can leave them in 2 tables, or SELECT into one cursor locally for the report. Either way will work, but I prefer the one-cursor method.
Now, back to what you were counting...
Do you just want to count the number of claims, and show it on the last page of the report? If so, SELECT COUNT(DISTINCT MyKey) FROM ... INTO ARRAY laMyCount, and reference laMyCount(1) in your report. You will find counting parents difficult with the report writer.
If something else, post again.
>Thanks again Cindy for you response but its a bit more complex than that.
>
>The main Table contains Claims made to the company. One claim can have several third parties. The Third Parties are striped into 3 Tables (Vehicles,Persons and Properties ((Each T/P Table have different fields.)).
>So for each claim I download all vehicles,persons,properties in question into one cursor called thirdParty. The posibility exist that there are no third parties.
>
>If there was just one table for for tp I could just do a left outer join which would still get all claims and include any t/p that exist but the tables are split.
>
>
>I want this format for the report
>
Claim Code Insured Name Phone
>-----------------------------------------------------
>cscs10303 Christopher Pinnock (876)924-1234
--> Name Vehicle # Insurer Tp Type
-----------------------------------------------------------------
Terry Jolly 5545 BJ United General Insurance Vehicle
Lyndon Wheeler BCIC Property
Corey Brown Person
cscs10303 Barry White (876)924-1234
--> Name Vehicle # Insurer Tp Type
-----------------------------------------------------------------
Pete Samphras 5445 CD BCIC Vehicle
cscs10303 Keith Brown (876)924-1234
cscs10303 Pete Abrahams (876)924-1234
