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
<*> 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/
