Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Design issue + cyclic table Required....

Status
Not open for further replies.

gyaja

Programmer
Jun 3, 2001
3
US
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
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top