Vantage 8.03.409a - BAQ Report Connection Error

I need to provide information for our Team Leaders that shows all orders due to the end of the current week with pending shipments removed. I don't think I can do this on a Dashboard as the ShipDtl table is summarised and I can't calculate on that total calculation?

So I decided to do a BAQ report and I get so far with it and then all of a sudden when I try to review with fresh data I get the following message:
Unknown Database Connector Error
Failed to retrieve data from the database.
Error in File (file path is on my temp drive)
Unknown Database Connector Error

If I try to set the database location from within Crystal reports I still get the Failed to retrieve data \ Connector Error. It seems to work fine for so long and then this... any suggestions? Thanks.