Report Design Help Required: Urgent

I have a cyclic table having parent child relation in the same table.
The snap shot of this table is :

m_id p_id d_id name
1 0 5 usb hub
1 0 6 sd card
1 5 7 power cord
2 0 1 brush
2 0 2 straw
3 0 1 fork
4 0 7 digi cam
4 7 8 flash card
and so on

The report displays data as grouped with m_id.
Further requirement is what I am not able to achieve. The requirement states that: The names of the items should be clubbed together for those records which have p_id = d_id

That means as per above table: the highlighted table data needs to be clubbed within the major group m_id
So the report for m_id should show:

m_id name
1 usb hub, power cord
2 sd card

4 digi cam, flash card.
and so on....
Kindly provide feedback,

Awaiting reply
Thanks
Ajay G

[1041 byte] By [AjayG] at [2007-12-16]
# 1
Hello Ajay,

I would recommend trying to solve this one the database side by using a stored procedure.

Trying to solve this on the Crystal Reports side might be possible by aliasing in your table and working with the joins, but then you would take a performance hit and it would get complicated.

Keith - Business Objects

KeithThomson at 2007-9-9 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...

Visual Studio

Site Classified