Kalo struktur field yang diakses sama tapi hanya beda criteria, coba pake aja method SetSQLSelect nya datawindow. Jadi cukup buat 1 datawindow object, tinggal diatur waktu runtime criteria query mana yang mau digunakan. Untuk lebih jelasnya baca aja helpnya. Okeh ??
Andi F. ----- Original Message ----- From: "yazid" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 03, 2005 9:26 AM Subject: [indopb] 2 query dlm 1 datawindow ??? > > > Hi semua ...need help, clue, inspiration nih... > > Saya ingin buat report, dari datawindow dulu. > Report tentang jmlh employee tiap dept > > DEPT LastMonth ThisMonth > A 10 8 > B 12 14 > > > utk membuat ini report di dw ini, dilihat kondisi > emp_joindate > emp_resigndate > > utk mendptkan LastMonth emp berarti querynya > "select count(emp_id) from employee where emp_joindate < thismonth-1 > and emp_resigndate >= thismonth-1" > > utk mendptkan ThisMonth emp berarti querynya > "select count(emp_id) from employee where emp_joindate < thismonth > emp_resigndate > thismonth" > > intinya utk membuat report itu ada 2 query dlm 1 dw, bgm caranya spy > hanya dlm 1 dw bisa menampilkan report diatas (hanya menggunakan > fasilitas dw)? > 1.apakah ada cara spy bisa menulis query kedua > 2.saya coba pake compute kolom, tapi tidak bisa dikondisikan > > thanks > yazid [Non-text portions of this message have been removed] ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
