Quote Originally Posted by pnish
Check that you're not saving data with the report. When designing a report, by default it saves the data with the report, which means that everytime you run the report you get the same original data.
Open your report in Crystal and have a look under the File menu and make sure that Save Data with Report is not checked.
Yeah, I am aware of that and its not checked. Right now, the only solution is to create two ODBC connections and change it every time I have to switch the databse....which sounds non professional....

Thanks.