Report Design issue + cyclic table Required....

[gyaja]

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:
Expected Result:
m_id name
1 usb hub, power cord
1 sd card

4 digi cam, flash card.


and so on....


Kindly provide feedback,

Awaiting reply
Thanks
Ajay G

 

[synapsevampire]

Add the table in a second time and join accordingly.

It will prompt for an alias, but then you can join it to the otehr table. I'd guess that you want a Left Outer.

-k

 

[gyaja]

I am trying to create this as a sub report. Also I am using .net embedded report designer, which hides many of the utilities.
The show query cannot be updated and the joins made as always inner joins.