Semacam report History Stok ya? Saran saya bagaimana jika data pergerakannya anda simpan ke tabel summary saja (buat package), baru kemudian report hy menampilkan saja..
definisikan dulu type2 pergerakan.. mis: R -> Retur (Retur) (+) S -> Sales (Jual) (-) B -> Buys (Beli) (+) for c in (select * from TRN_REG) loop -> row 1 qty_sum = nilai qty pertama qty = nilai qty -> row 2 if R1 then qty_sum = qty_sum + qty elsif ... elsif dst.. end loop semoga membantu... --- hyanamarta <[EMAIL PROTECTED]> wrote: > Sorry saya tdk bisa tampilan semua field ( terlalu > banyak ) > ini field yang di butuhkan > Table : TRN_REG > > TRN_DATE TRN_TYPE TRN_DOC PROD_ID TRN_QTY PROD_UOM > -------- -------- ------- ------- ------- -------- > 3/10/2005 R1 1536 0020001 25 BTL > 4/10/2005 SC 9632 0020001 5 BTL > 5/10/2005 S1 4236 0020001 40 BTL > dst > Report saya ingin menampilkan pergerakkan per produk > dalam suatu > periode tertentu. > > Thanks > > --- In [email protected], Fernando > Napitupulu > <[EMAIL PROTECTED]> wrote: > > > > Bagaimana info mengenai tabel2 yg menghasilkan > data > > tsb, jika syntax yg dimaksud adl query? > > > > --- hyanamarta <[EMAIL PROTECTED]> wrote: > > > Hi friends, > > > > > > Saya ingin membuat report seperti ini : > > > > > > Tgl Keterangan Masuk Keluar Saldo > > > 1-10-2005 Saldo awal 100 0 100 > > > 3-10-2005 Pembelian 25 0 125 > > > 4-10-2005 Retur 5 0 130 > > > 5-10-2005 Penjualan 0 40 90 > > > dst...... > > > > > > Bagaimana syntax yang harus saya gunakan ? > sekedar > > > info saya > > > menggunakan Database Oracle versi 8.1.7 __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
