Wrong database showing up in "show sql query" section of crystal reports
Posted on 2011-02-10
I have a report linked to a db called - sl_lis. when you look Database --> Set Datasource Location, it shows the correct datasource.
However, if you click on Database --> Show SQL Query, it shows it's pulling info from our "Reports" db.
How do I fix this? I know it's going off of Reports rather sl_lis because Reports only goes back to 2007 and the report i'm running is looking for data from 2006 and nothing's coming up.
Any help is greatly appreciated