Arsip: Menampilkan Data Tabel Master tanpa Tabel Detail

more 10 years ago
IdrisZZ
Mas, Gimana ya caranya menampilkan ke laporan Data Master-Detail. tetapi jika data di tabel Master gak ada Detail nya tetap tampil di laporannya. Contoh :
1. Master A
- Detal A.1
- Detal A.2
2. Master B
3. Master C
- Detal C.1
Terimakasih

more 10 years ago
denmasdanang
@IdrisZZ: Mas, Gimana ya caranya menampilkan ke laporan Data Master-Detail. tetapi jika data di tabel Master gak ada Detail nya tetap tampil di laporannya. Contoh : 1. Master A - Detal A.1 - Detal A.2 2. Master B 3. Master C - Detal C.1 Terimakasihcontoh tablenya bisa ga diperjelas? misalnya data dari table master diatas tidak ada relationnya contohnya seperti ini :
select masterA.field1 as A, detailA1.field1 as B, detailA2.field1 as C from masterA inner join detailA1 on masterA.field1 = detailA1.field1 inner join detailA2 on masterA.field1 = detailA2.field1
union all
select masterB.field1, '-' as B, '-' as C from masterB
union all
select masterC.field1, detailC1.field1, '-' as C from masterC inner join detailC1 on masterC.field1 = detailC1.field1
thxmore ...
- 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 1 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 1 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 2 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 9 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 9 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 9 years ago
Random Topic
- komponent export excel
by keylock in Tip n Trik Pemrograman more 13 years ago - nextgrid, quantumgrid, tmsgrid, which one da best?
by old_shutherhand in Tip n Trik Pemrograman more 14 years ago - Pencarian Eror and berhenti jika Filenya lagi di Pake
by avatar_eng in Tip n Trik Pemrograman more 14 years ago - GImana Cara Save dan Print DBGRID
by ari_volker in Hal umum tentang Pascal Indonesia more 14 years ago - Error waktu buat table di Interbase
by l1th1um in FireBird more 14 years ago - Atur Naik Turun Nada Lagu (Pitch Control)
by machomen in Multimedia & Graphic Enhancement more 15 years ago - Tanya Query SQL
by fat_279 in Tip n Trik Pemrograman more 13 years ago - bingung nyusun tampilan di quick report !
by flamade in Hal umum tentang Pascal Indonesia more 14 years ago - Indexing Document
by trimbil in Enginering more 12 years ago - ada yang pernah pake ISO buat transaksi ATM
by alvonz in Enginering more 13 years ago