Guys.. mau tanya, gua membuat report dgn report builder versi 6. Ketika di-running dengan output langsung di screen, semuanya tampak fine-fine aja. Tapi bila output itu dibuat ke dalam text file (di bagian system parameters, DESTYPE dipilih File untuk initial value-nya), yg terjadi layoutnya berantakan kira-kira seperti ini (tulisan terpotong dan dilanjutkan ke line berikutnya):
PT. XXX PERINCIAN PEMBAYARAN NOMOR 4489000106882 HALAMAN 1 Kepada Yth. Nomor Suppl 900001 PT ERES REVCO Nama JL HR RASUNA SAID KAV 10 padahal ketika output langsung di screen adalah sbb: PT. XXX PERINCIAN PEMBAYARAN NOMOR 4489000106882 di mana tulisannya bisa memanjang terus ke kanan, dan tulisan Kepada Yth. tersusun rapi di bagian paling kanan. Rgds, Darfan Wong jangan lupa ke sini.. http://moview21.blogspot.com Sent from my MuvieBerry powered by indoshut!! --- On Tue, 1/12/09, Andi Kurniawan <[email protected]> wrote: From: Andi Kurniawan <[email protected]> Subject: RE: [indo-oracle] Mx7 - Urutan To: [email protected] Date: Tuesday, 1 December, 2009, 3:19 PM Maksudnya pake descending sort ya Mas? select * from baju order by (kode_baju)desc; From: [email protected] [mailto:[email protected]] On Behalf Of Mx7 Sent: Tuesday, December 01, 2009 2:20 PM To: [email protected] Subject: [indo-oracle] Mx7 - Urutan @all iya thx semuanya .. dah saya coba pake commit agar data2 yang telah di update, delete, dsb ngga ilang lagi .. ada pertanyaan lain soal urutan yang ditampilkan .... saya coba ketik : select * from baju order by kode_baju; KODE_BAJU ------------- B-0001 B-0002 B-0003 B-0004 J-0001 J-0002 pertanyaannya : 1. Gimana caranya agar hasilnya urutan yang J dulu, baru yang B... maksudnya seperti ini : KODE_BAJU ------------- J-0001 J-0002 B-0001 B-0002 B-0003 B-0004 mohon bimbingannya ... terima kasih banyak ... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]
