ADO error: Invalid object name <object name>.

I tried to create a report that is based on a stored procedure and I get this error when I try to verify the SQL.

ADO error: Invalid object name '#MatPatAbsence'.

If I click on the RUN exclaimation mark, I get no data, but do get the column names.

#MatPatAbsence is a temporary table created in the stored procedure and deleted once used.

I have also created another similar report from a stored procedure that has temporary tables and all are working fine.

also this stored procedure runs fine in query analyzer.

Can any one help please?

paste your query, I will take a look