1 / 24

Reporting

Reporting. Name : frmRepBrg. Membuat form laporan di Project sebelumnya. Simpan dengan nama Lap_data_barang. TODBCConnection Name : conn Driver : MYSQL ODBC 5.2 ANSI DRIVER Params : server= localhost ; port=3306; database= barang ; Username & Password diisi.

jenna-gamble
Download Presentation

Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Reporting

  2. Name : frmRepBrg Membuat form laporandi Project sebelumnya • Simpandengannama • Lap_data_barang

  3. TODBCConnection Name : conn Driver : MYSQL ODBC 5.2 ANSI DRIVER Params : server=localhost; port=3306; database=barang; Username & Password diisi

  4. SQLTransaction Database : conn SQLQuery Database : conn SQL : SELECT * FROM tb_barang Transaction : SQLTransaction1

  5. DataSource Dataset: SQLQuery1 DBGrid DataSource : DataSource1 frDBDataSet Dataset : SQLQuery1 DataSource : DataSource1

  6. Double klikfrReport1 di form laporan File > Variable List … Value > SQLQuery1 BuatVariabelBaru : Klik Variables …

  7. GunakanSpasi

  8. Hubungkan masing2 variabeldengan Value2 :

  9. Pilih Tools “Band” LaluKlikdi area kanvas report

  10. Pilih Tools “Rectangle” LaluKlikdi area “Title” band report

  11. Simpandengannama “rekap_data_barang.lrf” Simpandi folder project berada NB. Agar berkasrapi, simpanpada folder tersendiri

  12. Buatlah band baruuntukmenampilkan Header data master

  13. Buatlah 4 Rectangle pada “Master header” Band Dan buatlah line dibawah band tsb

  14. Buatlah band baruuntukmenampilkan data master

  15. PilihDatasource : frDBDataSet1

  16. Buatlah 4 rectangle pada band tsb, danisikandengan masing2 variabel

  17. Buatlah band baruuntukmenampilkan Footer

  18. Buatlah 1 rectangle untukmenampilkanjumlah total stokbarang

  19. Function > Function > Aggregate >Sum Isikan Argument 1 dengan [Stok]

  20. Buatlah menu barudi Form Utama, Arahkan menu tsbuntukmenampilkan form laporan yang barudibuatsebelumnya

  21. Buatprosedur “Click” dari submenu tsb : NB. Uses lap_data_barang;

More Related