You''ll need to get the counts of each code before running the report, then link them back to the patient record. Multiple detail bands in VFP support parent->child->child, not grandparent->parent->child.

The doctor will be in the group header, patient and the codes in the first detail band, counts in the second.


>HI All
>I want to print a report that displays all the patients for a doctor with the code of each patient's disease.
>After this part I want to print a cumulative of each code of disease for patients of this doctor.
>
>I have a table that contains all patients of the doctor and another that contains the cumulative codes, these two tables are linked by a relation with the medical code.
>
>it look like this
>
>
>First table Alias
>
>Nom Med Code1 Code 2 Code 3
>Mr xxxxx 123 8800 8802 8803
>Mr. YYY 123 8800
>Mr. AAA 123 8802 8804
>
>
>Second Table
>
>Med Code Qty
>123 8800 2
>123 8802 2
>123 8803 1
>
>
>How can i print the first table informatyion and after that the second one
>I have Try to put the fields of the second table in the 2 second detail band and i have write the name of the second table in the taget Alias expression but the best i have got is something like this.
>
>
>Mr xxxxx 123 8800 8802 8803
>123 8800 2
>123 8802 2
>123 8803 1
>
>Mr. YYY 123 8800
>123 8800 2
>123 8802 2
>123 8803 1
>
>Mr. AAA 123 8802 8804
>123 8800 2
>123 8802 2
>123 8803 1
>
>
>Can you help me
>
>TIA
>Ben.