General information
Category:
Reports & Report designer
Larry,
I would also suggest that if Ken is wanting to show all the children he needs to make sure that his relationship is setup so that he has SET SKIP TO the child table and make sure the child fields are in the detail band of the report. He should also make sure he has selected the parent table before he issues the REPORT FORM command. This will make sure all of the child records get printed.
Dave :-)
>I'd suggest pre-processing the data to create a single parent-child >relationship where the child file contains field for ChildName and PetName. >For some child file records, the pet name would be empty and for others, the >child name would be empty.
>HTH
>Larry
>Set up your report data environment with the parent-child in relationship.
>
>Basically, in the report, the detail band would be:
>
>Parent.name
>"Children Pet"
>-------GROUP BAND ON PET------------
>Child.name Child.Pet
>
>
>How's that?
>
>
>>Ok - riddle me this,
>>
>>How can I get a report to print with a parent record and multiple-table child >>records? For example, suppose my parent table is "Person" - a person can have >>children and/or pets. How can I get the report to print something like this.
>>
>> JOHN DOE
>>CHILDREN PET
>>---------- ---------------------------
>>Bobby Fluffy
>>Tommy Spot
>>Sue
>>Ann
>>
>>JIM SMITH
>>CHILDREN PET
>>---------- ---------------------------
>>Sam Fido
>> Flipper
>> Lassie
>>
>>Larry Moody
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only