physical database not found

I have a stored procedure that i have created in sql.

i have not had any issues in the past until yesterday

when i create a NEW crystal report and use an ODBC connection, i can retrieve the sp but i receive an error

PHYSICAL DATABASE NOT FOUND.

If i take the same code and create a view or table, i can use those without a problem.

if i take an already created report and set my location to the sp i can use it and i dont get an errror.

My co-worker has no problem using the sp.

under options CHECK NULL VALUES BOX is greyed out as well.

any help will be greatly appreciated.