Hi all,

New to the forum and crystal reports as well, so this question shouldn't be too hard to answer but I've searched and browsed the forum for a bit and haven't found an answer.

I am using an application that defines an ODBC datasource which should be the database that the queries and stored procedures are run against.

I have had issues previously when using Database Expert (or at least I assume it was when I used database expert). It seems that sometimes when I used this feature, the queries would be run instead of "rep_StoredProcedure" it is run as "DB"."rep_StoredProcedure" and thus when I attempt to run the report against DB1 DB2 DB3 etc it would generate the SP query as "DB"."rep_StoredProcedure" and only hit this one DB. To get around this I re-created the report one step at a time, testing each time to see if the query had changed from "rep_StoredProcedure" to "DB"."rep_StoredProcedure". Inconvenient and time consuming, but it was the best I could come up with at the time.

Now I am having a problem with one of these reports that is actually generating the query fine most of the time, except when one specific report setting is set. Then it generates the query mapped to the specific DB.

TL;DR - Need my report to use ODBC connection defined in the application, when one report setting is set from the application it is mapped to a specific DB.

Can anyone point me in the right direction here? It's very confusing to me how these DB mappings are created, especially for just one case.