title: How do I set remove the database name from the query in Crystal Reports?
body: <p>We are a development firm integrating Crystal Reports 2013 into our software. I need the ability to remove the database name from the SQL Query generated by Crystal Reports. We have customers running multiple instances of our software using the same data server. So we need to remove the database name so when it connects it uses the database specified in our file.dsn for an ODBC connection. We are using SQL Server as our data source. Any help would greatly be appreciated.</p>