subreport query timing out??

A

Alan

Hello,

I have a report that contains a few subreports. One subreport in particular
seems to intermittently "disappear" as in it doesn't always show the data for
that record. The Child/Parent relationships are correct however what appears
to be happening is that if that particular subreport's query takes too long
to pull the data, it times out and the report basically skips it and displays
the rest of the report. No errors are thrown, it just skips that subreport
(leaves the subreport header there) and displays the rest.

As mentioned this is an intermittent thing. If it happens, I can close the
report, open it again and the report will be complete with all subreports
displayed with the proper info.

Does anyone have any ideas of how to stop this from happening or potentially
force the main report to wait for the subreport's query to run before
displaying itself?

Thanks,

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreport doesn't work with a query 0
Sum Subreport Row Data 1
Changing subreport orientation in main report? 3
Subreport page break in label controls or textbox controls 6
Subreport not displaying 5
Source Object changing on save of subreport 2
Subreport data intermittently not appearing 1
Re-post of Subreport with no records 0

Top