Pada Visual Basic .Net untuk untuk membuat Report
atau laporan data bisa menggunakan program bantu seperti Crystal Report atau
menggunakan komponen di Visual Basic .Net yang bisa digunakan untuk membuat Report.
Print Document adalah salah satu komponen di Visual Basic .Net yang bisa
digunakan untuk membuat Report, komponen Print Document memiliki beberapa
fungsi antara lain mengatur font, mengatur perataan teks, mencetak garis dan
mencetak gambar. Hasil desain Report data dari komponen Print
Document tergantung dari jenis printer yang aktif, untuk melihat hasil Report
data di layar kita membutuhkan jenis printer yang bisa mencetak dan menampilkan
data dalam format PDF seperti program AdobeReader. Berikut contoh kode program dan hasilnya :
Private Sub PDBARANG_PrintPage(ByVal
sender As Object,
ByVal e As
System.Drawing.Printing.PrintPageEventArgs) Handles
PDBARANG.PrintPage KIRI.Alignment = StringAlignment.Near TENGAH.Alignment =
StringAlignment.Center KANAN.Alignment = StringAlignment.Far
e.Graphics.DrawString("LAPORAN DATA BARANG", FONTJUDUL,
Brushes.Blue, 450, 25, TENGAH) e.Graphics.DrawLine(Pens.Black, 30, 70,
805, 70) e.Graphics.DrawString("NOMOR", FONTDATA, Brushes.Black, 100,
75, KANAN) e.Graphics.DrawString("KODEBRG", FONTDATA, Brushes.Black, 125,
75, KIRI) e.Graphics.DrawString("NAMA BARANG", FONTDATA, Brushes.Black,
200, 75, KIRI) e.Graphics.DrawString("HRG BELI", FONTDATA, Brushes.Black,
400, 75, KANAN) e.Graphics.DrawString("HRG JUAL", FONTDATA, Brushes.Black,
500, 75, KANAN) e.Graphics.DrawString("JML AWAL", FONTDATA, Brushes.Black,
575, 75, KANAN) e.Graphics.DrawString("JML BELI", FONTDATA, Brushes.Black,
650, 75, KANAN) e.Graphics.DrawString("JML JUAL", FONTDATA, Brushes.Black,
725, 75, KANAN) e.Graphics.DrawString("JML STOK", FONTDATA, Brushes.Black,
800, 75, KANAN) e.Graphics.DrawLine(Pens.Black, 30,
100, 805, 100) BARIS = 105 NOMOR = 1 TJMLAWAL = 0 TJMLBELI = 0 TJMLJUAL = 0 TJMLSTOK = 0 SQLSTR = "SELECT
* FROM BARANG" CMD = New
OleDbCommand(SQLSTR, KONEKSI) DR = CMD.ExecuteReader While
DR.Read e.Graphics.DrawString(NOMOR,
FONTDATA, Brushes.Black, 100, BARIS, KANAN) e.Graphics.DrawString(DR("KODEBRG"), FONTDATA, Brushes.Black,
125, BARIS, KIRI) e.Graphics.DrawString(DR("NAMABRG"), FONTDATA, Brushes.Black,
200, BARIS, KIRI) e.Graphics.DrawString(Format(DR("HRGBELI"), "#,#"),
FONTDATA, Brushes.Black, 400, BARIS, KANAN) e.Graphics.DrawString(Format(DR("HRGJUAL"), "#,#"),
FONTDATA, Brushes.Black, 500, BARIS, KANAN) e.Graphics.DrawString(DR("JMLAWAL"), FONTDATA, Brushes.Black,
575, BARIS, KANAN) e.Graphics.DrawString(DR("JMLBELI"), FONTDATA, Brushes.Black,
650, BARIS, KANAN) e.Graphics.DrawString(DR("JMLJUAL"), FONTDATA, Brushes.Black,
725, BARIS, KANAN) e.Graphics.DrawString(DR("JMLSTOK"), FONTDATA, Brushes.Black,
800, BARIS, KANAN) NOMOR = NOMOR + 1 BARIS = BARIS + 20 TJMLAWAL = TJMLAWAL + DR("JMLAWAL") TJMLBELI = TJMLBELI + DR("JMLBELI") TJMLJUAL = TJMLJUAL + DR("JMLJUAL") TJMLSTOK = TJMLSTOK + DR("JMLSTOK") End While e.Graphics.DrawLine(Pens.Black, 30,
BARIS + 5, 805, BARIS + 5) e.Graphics.DrawString("TOTAL : ", FONTDATA, Brushes.Black,
500, BARIS + 10, KANAN) e.Graphics.DrawString(TJMLAWAL,
FONTDATA, Brushes.Black, 575, BARIS + 10, KANAN) e.Graphics.DrawString(TJMLBELI,
FONTDATA, Brushes.Black, 650, BARIS + 10, KANAN) e.Graphics.DrawString(TJMLJUAL,
FONTDATA, Brushes.Black, 725, BARIS + 10, KANAN) e.Graphics.DrawString(TJMLSTOK,
FONTDATA, Brushes.Black, 800, BARIS + 10, KANAN) e.Graphics.DrawLine(Pens.Black, 30,
BARIS + 35, 805, BARIS + 35) DR.Close() End Sub
|