April 7, 2011 at 8:51 am
Arrrrrrgh! This is driving me mental. I have a report I am trying to build in SSRS. It's very similar to one I've already successfully built in the same project - just a few extra columns really, the same principals entirely.
For some reason after I've pasted the SQL in I get the above error: An Error Occured While The Query Design Method Was Being Saved. Invalid Object Name '#tmpA'
The other report which is very similar and works fine also begins with a temp table creation so I know that's not an issue. I tried wrapping the whole lot into a Stored Procedure too - the same results.
Both the SQL and the SP run just fine in Management Studio.
I've also tried on a different PC and within a different project.
Not sure what to do next to troubleshoot it, any thoughts guys?!
Cheers!
April 8, 2011 at 2:19 am
Finally sorted it out! - I was joining to another database which the user account I'm using in SSRS did not have permissions to access. I only got a half useful message to this effect from SSRS when I commented out anything involving parameters for some reason. With those in it just gave me the more cryptic message.
Oh well... sorted now \0/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply