Ad Hoc Query Reports are part of the report server database and not stored in physical files.  There is no direct functionality in Blackbaud CRM to export/import these reports across environments.

Reports created using Report Builder are stored in .rdl files.  These files can be moved across environments however the connection string will need to be modified to point to the new server name.