Pak Laurens, sudah saya coba dan berhasil.
thanks Benny --- On Thu, 10/1/09, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: Re: [indo-oracle] Need Help Oracle Report To: [email protected] Date: Thursday, October 1, 2009, 3:02 AM Gunakan statement sql select TRUNC(10.283 ,1), TRUNC(10.826 ,1), TRUNC(10.005 ,1) from [table] kemudian di report gunakan format mask NNNGNN0D0 CMIIW Laurens From: "ben_ronaldo7" <ben_ronaldo7@ yahoo.com> To: indo-oracle@ yahoogroups. com Date: 10/01/2009 01:35 PM Subject: [indo-oracle] Need Help Oracle Report Sent by: indo-oracle@ yahoogroups. com Guys, ada yang bisa bantu ga?? Misal gw ada field A (number) datanya seperti ini 10,283 ( akan gw munculin dicetak di oracle report) 10,2 10,826 ( akan gw munculin dicetak di oracle report) 10,8 10,005 ( akan gw munculin dicetak di oracle report) 10,0 10 ( akan gw munculin dicetak di oracle report) 10,0 jadi gw mau hanya mencetak 1 digit setelah koma tetapi tidak ada pembulatan. gw uda coba pake substr tp ga bisa karena patokan gw dari tanda (,) sedangkan jika angkanya 10 tidak ada komanya. Tolong pencerahannya. thanks Benny [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
