Data Source Change not reflected in SQL

[former_member604400]

Using Crystal Reports v13. We typically develop our crystal reports in our DEV environment and then move the report to our other environments. Once moved we update the data source to the new environment. Each of our 6 environments has its own Oracle 12g database.

I read in one answer to update each table instead of just the connection. I tried that and it still didn't seem to update the data source. That's based on me looking at the SQL after I've finished the update.

Also tried the log on and log off server, logging off each server and then on to only the correct server.

Have also tried the verify database, but this seems to say it's verified. Also, tried creating a new connection, but again no luck.

So, HOW do I change my datasource location to reflect the correct one?

[former_member11696]

Don't look at the SQL, it's CR Basic you are using so it's always going to show you the original SQL.

Export the report to RPT format and then preview the SQL to see what changed.

Also, compare data to confirm it's changed.

[former_member604400]

Actually, I did that. Even though the report was blank when running in PROD I exported it and then looked at the SQL again. It was still showing DEV.

[DellSC]

It sounds like you're doing the right thing to change the data source. Is the report not running correctly? Or is it just the query that's not updating?

-Dell

[former_member604400]

When the report is in the PROD environment it won't pull back any data. Pretty sure it's because the SQL is till looking at the DEV environment database. In DEV it runs fine.