Skip to Content
0
Former Member
Dec 06, 2006 at 07:35 AM

report

34 Views

Hi all,

My req is to get as shown below.

s.no plant material 304 883 979......

1 075 111 1

2 075 112 1 10

Here 304,883,979 are the components.This report shows tht for 111 material only 979 is the component exits and corresp quantity is 1.ANd 112 material consits of 304 and 979 components and corresponding quantity is 1 and 10 resp.I need the o/p in this format.U are getting components and quantity frm <b>stpo</b> table and material from <b>mast</b> table .How to get the o/p like this.Pls explain with a sample code.