If you have a vba report that takes a bit of time to work out the results then you should display progress to the user so that they know the report is working and hasn't crashed.
Andy Pope's website has some fantatic progress bars that you can download and use in your applications:
http://www.andypope.info/vba/pmeter.htm
