RE: [Programmer-VB] Report Per Month menggunakan VB dan Crystal R eport 8.0

[Junus Sinuraya]

Ribuan Terima Kasih atas saran dan ide2nya kawan2 semua,saya akan mencobanya dengan ide2 dari teman2   Regards, Yunus -----Original Message----- From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Andhi Y Sent: Tuesday, October 04, 2005 2:00 AM To: Programmer-VB@yahoogroups.com Subject: RE: [Programmer-VB] Report Per Month menggunakan VB dan Crystal Report 8.0 Kalau pakai Access, buat query baru sbb: SELECT a.Kode, a.Nama, (Select sum(qty) from tes where day(tanggal)=1 and tes.kode=a.kode) AS 1, (Select sum(qty) from tes where day(tanggal)=2 and tes.kode=a.kode) AS 2, (Select sum(qty) from tes where day(tanggal)=3 and tes.kode=a.kode) AS 3, (Select sum(qty) from tes where day(tanggal)=4 and tes.kode=a.kode) AS 4, (Select sum(qty) from tes where day(tanggal)=5 and tes.kode=a.kode) AS 5, (Select sum(qty) from tes where day(tanggal)=6 and tes.kode=a.kode) AS 6, (Select sum(qty) from tes where day(tanggal)=7 and tes.kode=a.kode) AS 7, (Select sum(qty) from tes where day(tanggal)=8 and tes.kode=a.kode) AS 8 FROM Tes  a GROUP BY a.Kode, a.Nama;   Simpan query tsb. Buka crystal report, ambil tabel dari query tsb   From: Junus Sinuraya [mailto:[EMAIL PROTECTED] Sent: Tuesday, 04 October 2005 1:51 PM To: 'Programmer-VB@yahoogroups.com' Subject: [Programmer-VB] Report Per Month menggunakan VB dan Crystal Report 8.0   Selamat siang rekan Vb semua, Saya ada persoalan tentang pembuatan report perbulan menggunakan Crystal Report, Persoalanya adalah: saya punya table : Table Recieve Part from Supplier   Kode_Part    Nama_Part        Qty    Tgl_Recieve    001               Pulpen            10        01-09-2005 002               Ruler               12       05-09-2005 003                Plastik           13        08-09-2005 004             Kanebo            16         07-08-2005 001            Pulpen               17        02-09-2005               saya ingin membuat Report seperti dibawah ini:                                                                                               Tgl              No.    Item                Name _Part            1         2        3        4        5        6        7        8        9  ....31 1        001                Pulpen                    10        17    - 2        002                Ruler                        -        -        -        -        12 Dst..   Mohon kawan2 VB membantu saya, atas kerjasama dan masukkannya saya ucapkan ribuan terima kasih   Ys. Note:"SELAMAT MENJALANKAN IBADAH PUASA"         "Mohon Maff Lahir Dan Bathin"       Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] YAHOO! GROUPS LINKS  Visit your group "Programmer-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.