Parent child relation ships in a report 1

[saran26]

Hi All,

I have parent id which is linked to three child records.

When i try to display the child id , in the group by parent section , i get only one child id displayed. I moved the child id to the detail section , it displays all child id three times. I tried to supress them by using supress by duplicates but still i am unable to.

Example:

*************************************************
Sample record

Parent id - 001 - child id are - 0001, 0002 and 0003
*****************************************************

If i have the child id in the group section it displays as follows
*********************************************************
------------------------------------------
Group section

parent id - 001

child id - 0001

-----------------------------------------------

**********************************************************
if move it to the details sections it displays as follows
**********************************************************
--------------------------------------------------
Group Section
parent id - 001

--------------------------------------------------

Details Section

0001
0002
0003
0001
0002
0003
0001
0002
0003

----------------------------------------------------------
***********************************************************

How to change my display setting so that it displays correctly.

Please help me out.

Thanks
Saran

 

[Madawc]

As well as grouping by parent id, group by child id. Show details just in the header or footer of the child id group.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[saran26]

Thank you

It helped a lot.

Saran