uppss.. ada yg tertinggal...

berikut system parameters-nya :

di bagian DESFORMAT 
datatype : character
width : 1024
intial value : dflt

DESTYPE
datatype : character
width : 80
initial value :file

Jadi, apakah ada setting yg salah? ataukah ada setting lain yg hrs diperhatikan?

Terima kasih sebelumnya...

Rgds,





Darfan Wong

jangan lupa ke sini.. http://moview21.blogspot.com

Sent from my MuvieBerry powered by indoshut!!

--- On Wed, 2/12/09, Darfan Wongso <[email protected]> wrote:

From: Darfan Wongso <[email protected]>
Subject: [indo-oracle] output di text file berbeda dengan output di screen
To: [email protected]
Date: Wednesday, 2 December, 2009, 9:52 AM

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]



------------------------------------

--
-----------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 addresses available on Yahoo!
Get the Email name you&#39;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]

Kirim email ke