H
homer
How to requery /refresh a report’s underlying query in detail_format or
Report_print event?
I have a report with record source binds to a query at design time. The data
are in sql server 2k. It has been running fine, but recently has experiencing
run-time error 2427 sporadically. My initial investigation made me believe
some of the scheduled jobs on the server may get into the way.
While I’m finding the bottleneck, I want to add code in the report to wait
couple second and retry, and I could not find the right syntax to do it.
In report,
Me!application.queries.query(“qryNameâ€).refresh
Or something in that effect… Thanks!
Report_print event?
I have a report with record source binds to a query at design time. The data
are in sql server 2k. It has been running fine, but recently has experiencing
run-time error 2427 sporadically. My initial investigation made me believe
some of the scheduled jobs on the server may get into the way.
While I’m finding the bottleneck, I want to add code in the report to wait
couple second and retry, and I could not find the right syntax to do it.
In report,
Me!application.queries.query(“qryNameâ€).refresh
Or something in that effect… Thanks!