Search results for query: *

I may have got it...after reboot i tried the override again, and got: SELECT SOFCM.CUSTOMER_NAME, SOFCM.CUSTOMER_ID, ARFIM.INVOICE_NUMBER, ARFIM.TERMS_CODE, ARFIM.INVOICE_DATE, ARFIM.CURRENT_BALANCE, ARFIM.INVOICE_AMT, ARFIM.SALESMAN_ID, ARFIM.ORDER_CLASS FROM JANUARY2009.dbo.ARFIM ARFIM...

Tried override table name, but it won't take. Rebooting that machine right now.

Ian, I think you're on to something... check out the joins: esidb is the production database, not my newly restored one. how do i change this? SELECT SOFCM.CUSTOMER_NAME, SOFCM.CUSTOMER_ID, ARFIM.INVOICE_NUMBER, ARFIM.TERMS_CODE, ARFIM.INVOICE_DATE, ARFIM.CURRENT_BALANCE, ARFIM.INVOICE_AMT...

Ian. I will try those and reply again. In the car.

Hi Dgillz, I tried to set for each table, this did not fix my problem. Still not sure why this is happening. Oy! The CFO is all over us to get these done. Any thoughts would help.

FYI... I just looked back at the report and noticed something...when I am in the Set Datasource Location (AFTER changing it), I expand each table in the report (there are only two tables), then properties of each table... I see the info like this: Jan2009 --Properties ----Database Type: ODBC...

Hi all! I saw this forum had regular responses, and I've already read through some of them and tried to fix my problem. I am IT Manager for a company and we are trying to run some of our normal reports against older versions of our database. The basis info on my environment: -- Database...