Saya sudah mengerti yang dimaksudkan.
Cuma apakah solusinya tidak berhasil? Compute_field yang saya maksud dalam point 1 itu nanti visiblenya dibuat false aja, supaya tidak kelihatan, toh gunanya hanya untuk mengetahui berapa baris pada group tersebut. -----Original Message----- From: aan (PCI) [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 3:54 PM To: [email protected] Subject: Fw: [indopb] fungsi sum di group 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 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 <*> 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/
