Author Topic: buat format '999,999.99' di repost designer ??  (Read 1100 times)

0 Members and 1 Guest are viewing this topic.

Offline @fm

  • Full Member
  • *
  • Posts: 68
buat format '999,999.99' di repost designer ??
« on: January 18, 2011, 04:58:58 PM »
kalo di txt file bisa paai ini
@PROW()+1,xkolom SAY '     Rp. '+trans(rupiah,'999,999.99')

kalo di report designer(RD) pakai apa ya? dgn sarat tak merubah di field RDnya (format expression kosong/blank), tapi cukup di form laporanya/merubah dari cursornya?

mohon saranya
« Last Edit: January 18, 2011, 05:01:17 PM by @fm »

Offline onytoo

  • Fox-id M.V.P
  • Hero Member
  • *
  • Posts: 1.032
Re: buat format '999,999.99' di repost designer ??
« Reply #1 on: January 18, 2011, 06:40:38 PM »
ya kalau field di rd nya gak mau di ubah, sudah pasti di cursornya yg harus diubah

SELECT field1,field2,....,TRANSFORM(rupiah, [999,999.99]) AS rupiah INTO CURSOR nama_cursor


Regards,
Onytoo
Long life Visual FoxPro...

Offline @fm

  • Full Member
  • *
  • Posts: 68
Re: buat format '999,999.99' di repost designer ??
« Reply #2 on: January 19, 2011, 10:51:42 AM »
thanks pak  :thumbsup:

lebih enak/simple kalo laporanya ada 2 jenis pilihan, bisa bulat(999) & pecahan (999.99)