Report data load time

[GraemeG]

Hello.

I seem to be having an issue with my reports. When I open them sometimes the data will load straight away and other times it takes 10-30 seconds and other times it wont load at all until I start clicking where data should be. The template loads i.e. labels etc. but no text boes which are linked to a query.

Any help would be much appeciated.

Also to add to the report os opened from a subform in a main form. But when I open the subform on its own and open the report its instant everytime.

 

[Galaxiom]

Could be partly due to a delay in the connection the back end on a network server.

Do you have something to keep the backend open when if no bound forms are open?

 

[GraemeG]

Thanks for reply. The front and back end are located togther at the minute as its under development. I am not sure what you mean by keeping backend open when if no bound forms are open. Also when I open the report itself on its own from the navigation panel it loads instantly every time.

 

[Galaxiom]

So the problem only happens when you open the report with a VBA command?

Regarding keeping the backend open:
The backend database is only open when there is something on the front end connected to the data. There is a delay if it needs to open so usually the developer will open a recordset or a form with a bound recordsource (sometimes a hidden form) and keep it open for the whole session.

Sometimes network problems make that situation worse but obviously that is not a problem in your situation.

 

[GraemeG]

Right ok.

Yeah it only becomes a problem when I open my database, it is set to hide all access features (runtime) so it looks like a stand-alone programme. Then the main form has commands which open a form within a subform (control source) then this subform has a command which opens the report.

Private Sub cmdKitchenTotalForecast_Click()
    DoCmd.OpenReport "Rep_Kitchens_30YRForecast", acViewReport
End Sub

However if I open the report on its own or even when I open the subform on its own and click the command to open the report its instant. So not sure if this is the VB or something to do with what you say in terms of loading record set with the report.

Just to add to this though. My report has lots of txt boxes with calculations adding fields together rather than info straight from the query and it is these fields that take the time to load.

 

[Galaxiom]

What happens if you open at table or query first and leave it open or minimised then use the button on the form?