Arsip: aku mau tanya tentang report
more 16 years ago
shefy
bantu aku ngebuat laporan bulanan donk.
yg kl dimasukin tgl awl n tgl akhir (tdatetimerpicker-maaf lp namanya :lol: )trus langsung di cetak pake quick report.
bingung banget... udah di cari-cari gak ada...
tolong bantu secepatnya ya... plissss.. thx buanget nget-nget... :?:
more 16 years ago
DelphiExpert
hampir semua orang butuh cepat... ngga' cuman anda... mau cepat tanpa dasar yg kuat ujung2nya gigit jari :mrgreen:
laporan yg anda inginkan (date-range) bisa dibuat cepat & mudah menggunakan SQL-Query...
tinggal SELECT xxx FROM xxx WHERE DateField Between :StartDateRange and :EndDataRange
terus tinggal dicetak pake QR
more 16 years ago
jimbot
:evil: twwwink.... twwwink ... :shock:
mongggo dulu donk ... jangan to-the-point
more 16 years ago
am4tiranDelphian
enakan pake filter az jadi laporannya gak hanya bisa perbulan bisa perminggu/perhari
pake cara seperti Suhu @delphiExpert juga bisa, atw pake Query
Select xxx From xxx Where tanggal>=:awal and tanggal<=:Akhir;
nb: awal adalah parameters tanggal; jadi @ Shefy buat 2 Tdatetimepicker (awal dan akhir);
Contoh coding:
Query1.Close;
Query1.SQL.text:='Select * From transaksi Where TglTransaksi>=:awal and <=:akhir';
Query1.ParamByName('Awal').AsDateTime:=DatetimePicker1.Datetime;
Query1.ParamByName('Akhir').AsDateTime:=DatetimePicker2.Datetime;
Query1.Prepare;
Query1.Open;
Smoga Membantu :shock:
more 16 years ago
baidlawi
itu cara bagus juga. tapi tanggal awal dan akhir harus selalu ada datanya. coba cara ini.
buatkan form dan siapkan edit1 untuk awal dan edit2 untuk akhir
Contoh coding:
var
t : string;
begin
t := '';
if edit1.text<>'' then t:= t+' and awal>='''+Edit1.text+'''';
if edit2.text<>'' then t:= t+' and akhir<='''+Edit2.text+'''';
if t<>'' then t:=' WHERE '+copy(t, 6, length(t)-5);
Query1.Close;
Query1.SQL.text:='Select * From transaksi '+t;
Query1.Open;
semoga bermanfaat
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Cenderung yang Mana ?
by budi_bunga in OOT more 17 years ago - Mengatur Nilai Awal & Akhir Range
by koi1 in Tip n Trik Pemrograman more 14 years ago - Topik lama... [Help]
by eksant in Tip n Trik Pemrograman more 17 years ago - Searhing Menggunakan Fungsi FILTERING...
by ii_irwan in Hal umum tentang Pascal Indonesia more 14 years ago - Langkah buat program Hotel
by reminder2k1 in Tip n Trik Pemrograman more 17 years ago - help
by vandy in onLinux more 17 years ago - Paradox Delphi 7 Error on Vista Home Premium
by claser99 in Paradox more 15 years ago - What do you thing..
by yayaretina in OOT more 17 years ago - TServerSocket and TClientSocket
by sulth4n in Tip n Trik Pemrograman more 18 years ago - Save hasil query di DBGrid ke dalam file Excel
by nunkee in MySQL more 13 years ago