I had an intuition prior to this that Sergiy might be from a non-US locale, but now I'm wondering what planet he is from.

If you are lucky enough to walk...

I'm pretty sure the tools provided by the native SSRS functionality won't allow doing what you are trying to do (at least SSRS2K) -three separate outputs with one set of...

I don't have the code to share but as a concept that I know would work you could use a small .Net wrapper application that provides the parameter UI, then...

I'd vote for keeping the full number of the 'needing help' items, but condense it as others have suggested as in just listing the posts' subjects and not a portion...

I have had the same issue\error message even with using temp tables in stored procedures. My solutions were to:

1) Use a @table variable instead of actual #temp table for relatively small...

I know this is a bit late but I ran across this as I was researching another SSRS issue.

Another reason subscriptions will stop running, which bit us a few times,...

I didn't see that you tried the parameter sniffing workaround in your code to reassign the input parameters to declared variables but you may have listed you original code.  I haven't inspected...

One quick test you can try in relation to the first section of Kevin's response is to DECLARE new variables within the body of the stored procedure matching the input parameters, assign the...

All these posts with happy people with nothing to do at the end of the year confirms my suspicions that DBA's are slackers .  ...

Lucky you, with things slowing down towards the end of the year.  In our organization, when people finalize wake up and realize that time is short,  we can typicallly expect...

The multi-value checkbox is only available with RS2005, the author mentions using RS2000 where this capability is not possible. 

Well if the local variable usage doesn't fix it then you do have a real head-scratcher.  I do however see a couple of places where you could change things which...

This subject has been posted before in this forum and I am not sure why this works this way, but as first thing in your procedure declare some local variables...

The scale of the photo is deceiving, the Columbia river at the point the photo is taken is about a half mile wide, and the banks are between 20 and...

David, this is great news and we have been wondering about this in our company as well in order to take advantage of some of the features in RS2005 that...