On hiding the subreport, I dont know whether or not the option to collapse if there is no data is available. However it would be possible in the main...

Is it possible to do the updates in one transaction, then do the indexing in a different transaction?