> klo tampilan report di CR kita design melalui coding bisa gak?
> masalahnya klo misalnya bstudi nya bertambah, kita gak perlu mendesign
ulang
> tampilannya di CR.
> atau emang ada cara tampilin report yg lain yg lebih fleksibel. maksudnya
> report didesign melalui coding, tapi hasilnya sama dg
> tampilan CR (bisa di preview dan bisa diprint).
> btw syntax yg tadi berlaku gak untuk database sql?
>
> ----- Original Message -----
> From: "ageng ar'" <[EMAIL PROTECTED]>
> To: "skdmdn" <[EMAIL PROTECTED]>
> Sent: Friday, January 13, 2006 11:53 AM
> Subject: Re: [vb-indo] Nanya buat report
>
>
> > ya kalo buat nampilin CR report khan di koding tinggal tempelin ajah
> control
> > CR nya di form, trus, di coding nya tinggal panggil control tersebut,
dan
> > buka reportnya, beres...
> > cuma untuk report CRnya khan emang kudu di design dulu reportnya di CR
> lalu
> > simpan dengan *.rpt dan file .rpt itu nanti yg di panggil lewat coding
VB
> > dan query itu anggap ajah sebagai storeprocedure yg emang untuk kasus
> > tertentu harus ada.
> >
> > mmm.. kaya nya kamu perlu explore lagi deh VB nya..
> > he..he.h.e..he..he..
> >
> > nih kalo mo sql syntaxnya...
> >
> > SQL syntax di query1:
> > SELECT Hasil_Ujian.NOPESERTA, Peserta.[NAMA PESERTA], Hasil_Ujian.KD_BS,
> > Bid_Studi.NM_BS, Hasil_Ujian.NILAI
> > FROM Peserta INNER JOIN (Bid_Studi INNER JOIN Hasil_Ujian ON
> Bid_Studi.KD_BS
> > = Hasil_Ujian.KD_BS) ON Peserta.NOPESERTA = Hasil_Ujian.NOPESERTA;
> >
> >
> > SQL syntax di query2 :
> > TRANSFORM Sum(Query1.NILAI) AS SumOfNILAI
> > SELECT Query1.[NAMA PESERTA]
> > FROM Query1
> > GROUP BY Query1.[NAMA PESERTA]
> > PIVOT Query1.NM_BS;
> >
> >
> > maksud kamu kamu pengen jalanin perintah ini lewat coding??
> > seperti :
> > conn.execute "TRANSFORM Sum(Query1.NILAI) AS SumOfNILAI
> > SELECT Query1.[NAMA PESERTA]
> > FROM Query1
> > GROUP BY Query1.[NAMA PESERTA]
> > PIVOT Query1.NM_BS;"
> >
> > mungkin kalo kamu jalanin query1 dengan cara seperti ini, mungkin masih
> > bisa, tapi kalau query2 gak mungkin bisa, dan pasti nimbul pesan error
> "Too
> > many parameters..bla...bla..bla..."
> > makanya untuk kasus ini kita memanfaatkan store procedure.
> > jadi langsung sperti ini:
> >
> > conn.execute "Query2"
> > ' yg nantinya si query2 juga bakalan panggil store procedure yg
tersimpan
> di
> > query1
> >
> > gitou lho....
> >
> >
> > ;-)
> >
> >
> > ----- Original Message -----
> > From: "skdmdn" <[EMAIL PROTECTED]>
> > To: "ageng ar'" <[EMAIL PROTECTED]>
> > Sent: Friday, January 13, 2006 11:52 AM
> > Subject: Re: [vb-indo] Nanya buat report
> >
> >
> > > lewat coding untuk buat reportnya mas. maksud saya sytnax lengkap
> sqlnya
> > > ----- Original Message -----
> > > From: "ageng ar'" <[EMAIL PROTECTED]>
> > > To: "skdmdn" <[EMAIL PROTECTED]>
> > > Sent: Friday, January 13, 2006 11:39 AM
> > > Subject: Re: [vb-indo] Nanya buat report
> > >
> > >
> > > > lewat coding untuk....?
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "skdmdn" <[EMAIL PROTECTED]>
> > > > To: "ageng ar'" <[EMAIL PROTECTED]>
> > > > Sent: Friday, January 13, 2006 11:18 AM
> > > > Subject: Re: [vb-indo] Nanya buat report
> > > >
> > > >
> > > > > makasih mas. btw klo lewat coding bisa gak ya? maaP mas, soale
> saya
> > > baru
> > > > > belajar
> > > > > ----- Original Message -----
> > > > > From: "ageng ar'" <[EMAIL PROTECTED]>
> > > > > To: "skdmdn" <[EMAIL PROTECTED]>
> > > > > Sent: Friday, January 13, 2006 11:01 AM
> > > > > Subject: Re: [vb-indo] Nanya buat report
> > > > >
> > > > >
> > > > > > file formatnya ms access (*.mdb)... cuma aku zip...
> > > > > > trus... nama file "db2.zip" nya aku ilangin supaya gak ke blok
> sama
> > > > > > firewall kantor, jadi nanti begitu kamu save, kamu rename yah :
yg
> > > > tadinya
> > > > > > "db2" --> rename menjadi "db2.zip" (tanpa tanda kutip) dan
> extract
> > > file
> > > > > > tsbt, ngerti khan yah..... oke..
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "skdmdn" <[EMAIL PROTECTED]>
> > > > > > To: <[EMAIL PROTECTED]>
> > > > > > Sent: Friday, January 13, 2006 10:40 AM
> > > > > > Subject: Re: [vb-indo] Nanya buat report
> > > > > >
> > > > > >
> > > > > > > mas ageng, attachnya bisa dikirm via japri gak? tolong
dong...:)
> > > > > > > ----- Original Message -----
> > > > > > > From: "ageng ar'" <[EMAIL PROTECTED]>
> > > > > > > To: <[EMAIL PROTECTED]>
> > > > > > > Sent: Friday, January 13, 2006 10:04 AM
> > > > > > > Subject: Re: [vb-indo] Nanya buat report
> > > > > > >
> > > > > > >
> > > > > > > > ooo my god.... milis ini gak bisa ngirim attach yah.... i'm
so
> > > > > > soowwyyy...
> > > > > > > > tapi liat di nb pada email ku sebelumnya yah...
> > > > > > > >
> > > > > > > > ----- Original Message -----
> > > > > > > > From: "ageng ar'" <[EMAIL PROTECTED]>
> > > > > > > > > ini aku bikinin samplenya di ms access cuma belom sampai
CR,
> > di
> > > CR
> > > > > nya
> > > > > > > > kamu
> > > > > > > > > design sendiri, bisa yah...
> > > > > > > > > sama ajah kok ngaitin table umunya.
> > > > > > > > >
> > > > > > > > > hasil akhirnya yg kamu mau ada di crosstab query2, tinggal
> di
> > > > > explore
> > > > > > > > lagi.
> > > > > > > > > o iyah, file yg aku attach ini extensionnya aku hapus,
nanti
> > > kamu
> > > > > > rename
> > > > > > > > > nama filenya tambahan extension ".zip" (tanpa tanda kutip)
> dan
> > > > > extract
> > > > > > > > file
> > > > > > > > > zipnya.
> > > > > > > > >
> > > > > > > > > see.. you....
> > > > > > > > > mungkin temen2 lain ada yg bisa kasih pencerahan...
> > > > > > > > > ---------------------------------------
> > > > > > > > >
> > > > > > > > > nb: (milis ini bisa ngirim attachment gak yah????)
> > > > > > > > >
> > > > > > > > > SQL syntax di query1:
> > > > > > > > > SELECT Hasil_Ujian.NOPESERTA, Peserta.[NAMA PESERTA],
> > > > > > Hasil_Ujian.KD_BS,
> > > > > > > > > Bid_Studi.NM_BS, Hasil_Ujian.NILAI
> > > > > > > > > FROM Peserta INNER JOIN (Bid_Studi INNER JOIN Hasil_Ujian
ON
> > > > > > > > Bid_Studi.KD_BS
> > > > > > > > > = Hasil_Ujian.KD_BS) ON Peserta.NOPESERTA =
> > > Hasil_Ujian.NOPESERTA;
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > SQL syntax di query2 :
> > > > > > > > > TRANSFORM Sum(Query1.NILAI) AS SumOfNILAI
> > > > > > > > > SELECT Query1.[NAMA PESERTA]
> > > > > > > > > FROM Query1
> > > > > > > > > GROUP BY Query1.[NAMA PESERTA]
> > > > > > > > > PIVOT Query1.NM_BS;
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > ----- Original Message -----
> > > > > > > > > From: "skdmdn" <[EMAIL PROTECTED]>
> > > > > > > > > > mas ageng, bisa lebih jelas? soale saya ini pemula
> > banget...:)
> > > > > > > > > > ----- Original Message -----
> > > > > > > > > > From: "ageng ar'" <[EMAIL PROTECTED]>
> > > > > > > > > > To: <[EMAIL PROTECTED]>
> > > > > > > > > > Sent: Friday, January 13, 2006 8:53 AM
> > > > > > > > > > Subject: Spam Re: [vb-indo] Nanya buat report
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > > > > kelihatannya mesti pake cross-tab nih !!
> > > > > > > > > > > design dulu storeproc buat cross-tab ini di database,
> trus
> > > CR
> > > > > udah
> > > > > > > > > support
> > > > > > > > > > > buat bikin report model gini koq
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > ----- Original Message -----
> > > > > > > > > > > From: "skdmdn" <[EMAIL PROTECTED]>
> > > > > > > > > > > > Salam VB,
> > > > > > > > > > > >
> > > > > > > > > > > > Saya mempunyai tabel sbb:
> > > > > > > > > > > >
> > > > > > > > > > > > 1. Tabel B.Studi
> > > > > > > > > > > > KD_BS NM_BS
> > > > > > > > > > > > 1 MATEMATIKA
> > > > > > > > > > > > 2 FISIKA
> > > > > > > > > > > > 3 KIMIA
> > > > > > > > > > > >
> > > > > > > > > > > > 2. Tabel Hasil_Ujian
> > > > > > > > > > > >
> > > > > > > > > > > > NOPESERTA KD_BS NILAI
> > > > > > > > > > > > 111111111 1 xxx
> > > > > > > > > > > > 111111111 2 xxx
> > > > > > > > > > > > 111111111 3 xxx
> > > > > > > > > > > > 222222 1 xxx
> > > > > > > > > > > > 222222 2 xxx
> > > > > > > > > > > > 222222 3 xxx
> > > > > > > > > > > > dst
> > > > > > > > > > > >
> > > > > > > > > > > > 3. Tabel Peserta
> > > > > > > > > > > > NOPESERTA NAMA PESERTA
> > > > > > > > > > > > 11111111 ABC
> > > > > > > > > > > > 222222 DEF
> > > > > > > > > > > > Saya ingin membuat report seperti ini:
> > > > > > > > > > > >
> > > > > > > > > > > > NO.PESERTA NAMA PESERTA MATEMATIKA
> > FISIKA
> > > > > > KIMIA
> > > > > > > > > > > > 111111111 ABC
> > > > xxx
> > > > > > > > > > > xxx xxx
> > > > > > > > > > > > 222222 DEF
> > > xxx
> > > > > > > > > > > xxx xxx
> > > > > > > > > > > >
> > > > > > > > > > > > Bagaimana cara membuat report di atas melalui
Crystal
> > > > Report?
> > > > > > > > > > > > FYI saya menggunakan Crystal Report 8.5 dan database
> > > dibuat
> > > > > > dengan
> > > > > > > > SQL
> > > > > > > > > > > Server 97
> > > > > > > > > > > >
> > > > > > > > > > > > Thank's atas bantuan teman2.
> > > > > > > > > > > >
> > > > > > > > > > > > FYI sy pake Crystal Report 8.5
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Mailing list VB berbahasa Indonesia untuk para pengguna
> serta
> > > fans
> > > > > VB.
> > > > > > > > >
> > > > > > > > > Yahoo! Groups Links
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Mailing list VB berbahasa Indonesia untuk para pengguna
serta
> > fans
> > > > VB.
> > > > > > > >
> > > > > > > > Yahoo! Groups Links
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-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/
