 04-08-2010, 9:48 PM
|
hazelkasim
Joined on 04-09-2010
Posts 2
|
Error 5000 : Error in processing report. [extended info : subreport for control subreport1 failed. Failure due to : timeout expired]
|
|
|
|
|
Hi,
I have problem with this..
This is my code (in form 'frmShowReport')
Set rpt = New rptReport1
CN.Execute "exec sp_user @Date = '" & Format(dtp(0).Value, "yyyy/MM/dd") & "'"
rpt.Ado.ConnectionString = CN.ConnectionString
rpt.Ado.CommandTimeout = 180
rpt.Ado.ConnectionTimeout = 180
SQL = "exec sp_user2 @DateS = '" & Format(dtp(0).Value, "yyyy/MM/dd") & "', @DateE = '" & Format(dtp(1).Value, "yyyy/MM/dd") & "'"
rpt.Ado.ConnectionString = CN.ConnectionString
rpt.Ado.CommandTimeout = 180
rpt.Ado.ConnectionTimeout = 180
rpt.Ado.Source = SQL
This is code (in 'rptReport1')
Private Sub ActiveReport_ReportStart()
Set SubReport1.object = New rptReport1_Summary
SubReport1.object.Ado.ConnectionString = CN.ConnectionString
SubReport1.object.Ado.CommandTimeout = 60
SubReport1.object.Ado.ConnectionTimeout = 60
SubReport1.object.Ado.Source = "exec sp_user_last @DateS = '" & Format(frmShowReport.dtp(0).Value, "yyyy/MM/dd") & "', @DateE = '" & Format(frmShowReport.dtp(1).Value, "yyyy/MM/dd") & "' "
End Sub
anyone can help me to solve this problem..
Thank Q
|
|
|
|
|
Report
|
|
|
|