coba pakai coding dibawah ini:
Set adoPrimaryRS7 = New Recordset
adoPrimaryRS7.Open " DELETE FROM TMP_REPORT_1 " & _
" INSERT INTO TMP_REPORT_1 SELECT * FROM
NAMA_TABLE " & _
" WHERE TANGGAL BETWEEN '01/01/2007' AND
'01/31/2007'", db, adOpenStatic, adLockOptimistic
Report1.ReportFileName = "C:\NAMA_FOLDER\FILENAME.rpt"
Report1.WindowLeft = Report1.WindowWidth / 2
Report1.WindowTop = Report1.WindowHeight / 2
Report1.WindowState = crptNormal
Report1.Action = 1
mudah2an bisa membantu...
----- Original Message -----
From: vbPian
To: [email protected]
Sent: Friday, March 16, 2007 14:33
Subject: RE: Re[2]: [Programmer-VB] parameter crystal report via VB - Diulang
lagi
udah dicoba seperti ini belum?
report.formulafields.getItemName("tglAwal")="{Closing.periode}>=Date(" &
Year(formDatePickerAwal) & ", " & Month(formDatePickerAwal) & ", " &
Day(formDatePickerAwal) & ")"
report.formulafields.getItemName("tglAkhir")="{Closing.periode}>=Date(" &
Year(formDatePickerAkhir) & ", " & Month(formDatePickerAkhir) & ", " &
Day(formDatePickerAkhir) & ")"
Ini yang saya maksud pada reply-an saya sebelumnya :p
Kalo masih juga salah boleh disharing code prosedur pemanggilan reportnya.
CMIIW
vbPian
[zZzz]
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of
Lilis Suryani
Sent: Friday, March 16, 2007 2:11 PM
To: [email protected]
Subject: RE: Re[2]: [Programmer-VB] parameter crystal report via VB -
Diulang lagi
hallo mas vbPian dan Heri,
thanks ya atas usahanya tapi msh tetep tuh ga bisa
juga.
aku dah habis2an coba sana-sini dg formula tapi tetep
ada error.
aku coba spt ini :
report.formulafields.getItemName("tglAwal")="{Closing.periode}>=
formDatePickerAwal"
report.formulafields.getItemName("tglAkhir")="{Closing.periode}>=
formDatePickerAkhir"
dari perintah ini ada error " invalid name"
padahal nama parameter di crystal emang itu. hugh
sebel deh
trus aku coba pake spt ini:
report.selectionrecord={Closing.periode} IN #" &
FormPickerAwal & "# TO #" & FormPickerAkhir & "#
sama aja msh error.
tapi kalo ditest di crystal reportnya mah ga ada
masalah, gmn ya?
mas-mas yg lain bantuin donk?
lis
__________________________________________________________
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
