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
-----------------------------------------------
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/
