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.