I tried to create report with Report Services but if my stored procedure use temp table (ex: #Temp), I'll get the error "There is an error in the query. Invalid object name '#Temp'). If the stored procedure doesn't include temp table, it will be OK, the report could be created. I have no idea what's going on here. if anybody can give me a hand? Thanks a lot.