nick,

The error is pretty specific.  Apparently the login used by your ASP report
still has access to the database, but not to that stored procedure.  It
could be that someone changed the rights being granted the report user. You
can check what rights it still has by:

EXEC sp_helprotect @username = 'YourReportUserAccount'

However, a more likely suspect is that a new version of the stored procedure
was created , but the rights were not regranted.  This is a problem when a
stored procedure is dropped and recreated.  You can check by:

select name, crdate
from sysobjects
where name = 'IFMSpVisitbyStatus'

If that is the case, some one will need to:

GRANT EXECUTE ON IFMSpVisitbyStatus TO YourReportUserAccount

Also, if that is the problem then the process for deploying updated SQL
Server objects apparently needs to be tightened up a bit to ensure that
rights are preserved or regranted.

RLF