kayaknya maksud saya bukan seperti itu ... bisa ga sy kirim via japri dlm attachment, kalau mas wahyu mau bantu sich....... biar jelas maksud saya...!
tks aan ----- Original Message ----- From: "Wahyu Kurniawan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, February 20, 2006 2:38 PM Subject: RE: [indopb] fungsi sum di group > Waduh ternyata di reply hehehe > > Harus tanggung jawab nih, sorry nih salah persepsi. > > Klo kondisinya seperti di bawah, harus sedikit diakalin > > > > 1. buat compute field untuk menghitung jumlah data setiap sub, isinya > sbb: > > rowcount() for group_1 (gak tau nih bisa apa enggak) > > misalnya namanya sub_row_count > > 2. Lihat properties visible dari compute_field yang dibuat > > Disitu bisa ditambahin script, klo gak salah disebelah kanannya itu ada > tombol kecil warna merah > > Jika diklik akan muncul dialog window expression untuk memasukkan > script-nya > > > > Masukkan script berikut: > > > > If (sub_row_count>1,1,0) > > > > Aduh maaf nih klo salah > > > > > > -----Original Message----- > From: aan [mailto:[EMAIL PROTECTED] > Sent: Monday, February 20, 2006 12:34 PM > To: [email protected] > Subject: Re: [indopb] fungsi sum di group > > > > - mas wahyu , justru fungsi tsb memang benar saya buat trailer group , > > karena fungsinya menjumlahkan group...! > > > > contoh > > ======================================== > > Item Invoice No Facroty Qty Amount > > ======================================== > > 1 inv-001 Nike 10 1500 > > sub Total 10 1500 > > > > 2 inv-002 Adidas 15 2000 > > Sub Total 15 2000 > > > > 3 inv-003 Adidas 20 2500 > > Sub Total 25 2500 > > > > 4 dst > > > > - jadi maksud saya kalau hasilnya 1 baris fungsi sum di group tidak > muncul > > kalau lebih dari dua baris maka fungsi sum aktif > > > > - Cara visible datawindow object bagaiamana caranya...? > > > > tks > > aan > > ----- Original Message ----- > > From: "Wahyu Kurniawan" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Monday, February 20, 2006 11:48 AM > > Subject: RE: [indopb] fungsi sum di group > > > > > > > 1. Supaya tidak berulang. > > > > > > bagian sum jangan diletakkan pada bagian detail, tapi di bagian > group_1 > > > > > > > > > > > > 2. untuk menghilangkan fungsi sum jika 1 baris > > > > > > setiap object dalam datawindow itu kan punya properties > > > > > > fungsi sum itu adalah object compute_field > > > > > > coba lihat di help mengenai DATAWINDOW OBJECT PROPERTIES > > > > > > nah mainin aja properties visible-nya > > > > > > > > > > > > semoga membantu > > > > > > > > > > > > > > > > > > -----Original Message----- > > > From: aan [mailto:[EMAIL PROTECTED] > > > Sent: Monday, February 20, 2006 11:39 AM > > > To: [email protected] > > > Subject: [indopb] fungsi sum di group > > > > > > > > > > > > > > > > > > Rekan PB saya punya kesulitan nich menggunakan data window: > > > > > > saya menggunakan fungsi sum di group ( lihat kotak merah Figure > 1) > > > > > > > > > > > > tetapi hasilnya setelah saya run setiap baris fungsi > tersebut > > > > > > berulang-ulang muncul > > > > > > > > > > > > Pertanyaan saya : > > > > > > 1. Bagaimana menggunakan fungsi sum di group ..? Agar hasil > nya > > > > > > tidak berulang-ulang > > > > > > maksud saya kalau ada satu baris fungsi sum hilang (di > drop) > > > > > > kecuali kalau lebih dari satu baris baru fungsi sum tsb aktif > > > > > > > > > > > > Mohon buaaaanget bantuannya > > > > > > > > > > > > > > > > > > Figure 1 > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > ---- > > > > > > ------- > > > > > > 1. Header group invoice_no > > > > > > > ------------------------------------------------------------------------ > > > ---- > > > > > > ------- > > > > > > exportd_amount > > > exportd_tqty > > > > > > > ------------------------------------------------------------------------ > > > ---- > > > > > > ------- > > > > > > Detail ^ > > > > > > > ------------------------------------------------------------------------ > > > ---- > > > > > > ------ > > > > > > sum(ac_exportd_amount for group 1 ) sum(ac_exportd_tqty > > > for > > > > > > group 1 ) > > > > > > > ------------------------------------------------------------------------ > > > ---- > > > > > > ------ > > > > > > 2. Trailer Group invoice_no^ > > > > > > > ------------------------------------------------------------------------ > > > ---- > > > > > > --------- > > > > > > > > > > > > > > > > > > > > > > > > Thanks and Best Regards, > > > > > > AAN > > > > > > ================================= > > > > > > POU CHEN Corporation > > > > > > PT. Nikomas Gemilang > > > > > > EDP Department > > > > > > hunting 0254-401586 ext . 7192 > > > > > > E-mail : [EMAIL PROTECTED] > > > > > > ============================= > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ----------------------------------------------- > > > > > > IndoPB - Indonesia PB User Group > > > > > > To Post a message, send it to: [EMAIL PROTECTED] > > > > > > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > > > > > > Yahoo! Groups Links > > > > > > > > > > > > http://groups.yahoo.com/group/indopb/ > > > > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > http://docs.yahoo.com/info/terms/ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > ----------------------------------------------- > > > IndoPB - Indonesia PB User Group > > > To Post a message, send it to: [EMAIL PROTECTED] > > > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > ----------------------------------------------- > > IndoPB - Indonesia PB User Group > > To Post a message, send it to: [EMAIL PROTECTED] > > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > > Yahoo! Groups Links > > > > http://groups.yahoo.com/group/indopb/ > > > > [EMAIL PROTECTED] > > > > http://docs.yahoo.com/info/terms/ > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
