Numpang tanya ama mas Cokro. Mas, kalo kita setup custom paper untuk
crystal report di computer kita, kira-kira perlu nga yah kita setup
custom pape juga dikomputer client. thks
Best Regards,
Layong Lim
PT. Indomobil Trada Nasional
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of Cokro Fidian
Sent: Thursday, November 17, 2005 2:21 PM
To: [email protected]
Subject: Re: [indoprog-vb] nanya cara buat nota penjualan dengan crystal
report 8.5.tolonnnnngggggg URGENT kali
data2 tabel yg anda berikan tidak memenuhi aturan normalisasi, sehingga
sulit utk dibuat relation antar tabel, karena tabel transaksi terdapat
redudansi data.
anda punya tabel salesman tetapi di tabel transaksi tidak ada field
kode salesman utk dijadikan foreign key agar dapat dibuat relation antar
2 tabel tersebut.
tabel transaksi anda berisi gabungan transaksi penjualan, retur &
pembelian. sebaiknya masing kelompok transaksi dipisah ke tabel yg
berbeda.
anda tidak menuliskan isi tabel barang, entah itu sebenarnya ada atau
tidak pada database anda.
saran saya sebaiknya anda menormalisasikan dahulu database anda
minimal spt berikut (untuk penjualan):
1. tabel customer (kdLgn, nmLgn, almLgn)
2. tabel salesman (kdSales, nmSales)
3. tabel barang (kdBrg, nmBrg, satuan)
4. tabel jualMaster (noJual, tglJual, kdLgn, kdSales)
5. tabel jualDetail (noJualDetail, noJual, kdBrg, qtyJual, hargaJual)
jgn lupa bangun relasi antar tabel.
untuk membuat report anda bisa memanfaatkan view, sehingga anda hanya
perlu memanggil view tsb di crystal report.
utk ukuran kertas, anda bisa membuatnya dengan membuka control panel,
printers & faxes, klik kanan di area kosong, pilih create new form
(win2k/xp)
semoga dapat membantu
good luck
antony antony <[EMAIL PROTECTED]> wrote:
salam semuanya,
ada yang bisa bantu saya gak ya cara buat report di crystal report
8.5???????saya kebinggungan nih..
gini saya ada 3 buah tabel antara lain:
1. Tabel Customer
Kode Nama Alamat
L001 Langganan 1 jl. sudirman
L002 Langganan 2 Jl. sutomo
L003 Langganan 3 Jl. Asia
2. Tabel Salesman
kode Nama
S001 Salesman 1
S002 Salesman 2
3. Tabel Transaksi
Kode Nama
Nota Tanggal Kode Nama stock Stock qty
Harga ket
JL001 01/11/05 L001 Langganan 1 ST001 Mouse 1 25000
JL -> jual
JL001 01/11/05 L001 Langganan 1 ST002 Monitor 1 840000
JL -> jual
JL001 01/11/05 L001 Langganan 1 ST003 Cover 1 5000
JL -> jual
JL001 01/11/05 L001 Langganan 1 ST004 Speaker 1 55000
JL -> jual
BL001 02/11/05 P001 Supplier 1 ST001 Mouse 1
20000 BL -> beli
BL001 02/11/05 P001 Supplier 1 ST001 Speaker 1 50000
BL -> beli
JL002 03/11/05 L002 Langganan 2 ST001 Mouse 1 25000
JL -> jual
BL002 03/11/05 P002 Supplier 2 ST001 Mouse 1
20000 BL -> beli
RJ001 03/11/05 L001 Langganan 1 ST001 Mouse 1 20000
BL -> retur
JL003 06/11/05 L003 Langganan 3 ST004 Speaker 1 55000
JL -> jual
JL003 06/11/05 L003 Langganan 3 ST002 Monitor 1 840000
JL -> jual
RJ001 06/11/05 L002 Langganan 2 ST002 Monitor 1
800000 BL -> retur
RB001 07/11/05 P002 Supplier 2 ST001 Mouse 1
20000 BL -> retur
kira-kira data saya ada seperti itu.nah gimana cara buat reportnya
ya.saya belum pernah buat report yang menggunakan link table.jadi ada
yang bisa bantu saya gak ya.kalo bisa tolong kasih langkah2 nya ya.udah
urgent..................... kali...............
format faktur penjualan yang saya mau adalah
Faktur PEnjualan
Kepada :
Nota :
Langganan 1
Tanggal :
Alamat
kode salesman
telepon
no. kode stock nama stock qty jumlah
1
2
3
4
5
total
dan bagaimana format kertasnya jika saya mau cetak di countinuos form
yang ukuran 91/2 x 11 (ukuran quarto full ) dengan ukuran quarto yang di
bagi 2???????.
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke :
[EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
SPONSORED LINKS
Computer internet security Computer internet business
Computer internet access Computer internet privacy securities
Computer internet help Computer internet connection
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indoprog-vb" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Send instant messages to your online friends
http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke :
[EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
SPONSORED LINKS
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+security&w1=Compu
ter+internet+security&w2=Computer+internet+business&w3=Computer+internet
+access&w4=Computer+internet+privacy+securities&w5=Computer+internet+hel
p&w6=Computer+internet+connection&c=6&s=198&.sig=V04yaONvhRiZX9V-9vaMcA>
internet security
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+business&w1=Compu
ter+internet+security&w2=Computer+internet+business&w3=Computer+internet
+access&w4=Computer+internet+privacy+securities&w5=Computer+internet+hel
p&w6=Computer+internet+connection&c=6&s=198&.sig=QEM5QXY5E4yokvfp8I9OxA>
internet business
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+access&w1=Compute
r+internet+security&w2=Computer+internet+business&w3=Computer+internet+a
ccess&w4=Computer+internet+privacy+securities&w5=Computer+internet+help&
w6=Computer+internet+connection&c=6&s=198&.sig=GvFjo1UJpzPMTQeQeWH-9Q>
internet access
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+privacy+securitie
s&w1=Computer+internet+security&w2=Computer+internet+business&w3=Compute
r+internet+access&w4=Computer+internet+privacy+securities&w5=Computer+in
ternet+help&w6=Computer+internet+connection&c=6&s=198&.sig=2cAxh4C_HeZYn
GK5pWGQjg> internet privacy securities
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+help&w1=Computer+
internet+security&w2=Computer+internet+business&w3=Computer+internet+acc
ess&w4=Computer+internet+privacy+securities&w5=Computer+internet+help&w6
=Computer+internet+connection&c=6&s=198&.sig=XyuTAshDdmCMqHSTUW6r1Q>
internet help
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+connection&w1=Com
puter+internet+security&w2=Computer+internet+business&w3=Computer+intern
et+access&w4=Computer+internet+privacy+securities&w5=Computer+internet+h
elp&w6=Computer+internet+connection&c=6&s=198&.sig=PWZ1Hrcj8Yl7bPjnNBOES
g> internet connection
_____
YAHOO! GROUPS LINKS
* Visit your group "indoprog-vb
<http://groups.yahoo.com/group/indoprog-vb> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/zCsqlB/TM
--------------------------------------------------------------------~->
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
<*> 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/
