personal computer or work?

local admin?

have you logged in by chance with the wrong account?

Do you have this file on your computer?

"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\PROFILER.EXE"

Stefan Krzywicki (4/18/2012)

---

jcrawf02 (4/18/2012)

---

Stefan Krzywicki (4/18/2012)

---

Just complaining for a second

Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it...

This never happened

;-);-):sick:

You really need to contact your rep about that one.

Then just use a table variable. The only reason to not table variables for this report would be if there is a serious performance impact running the proc.

Are you using the report wizard or did you try to manually create a blank report?

Have you tried altering the dataset to use a command and type execute procname rather...

Brandie Tarvin (4/18/2012)

---

How about a slight change of subject. Still "worst questions" but of the humorous sort.

We've all heard about the admin assistant who switched from typewriters to computers and...

And when you test the dataset here, it errors?

I would say that the optimizer deems it too complex and it probably throws a memory error trying to cache it. This sort of thing can happen with vary...

SQLKnowItAll (4/18/2012)

---

I think since it is used in MAX(), it...

So the question remains, how are you calling the stored procedure in your dataset?

Looks like you started a couple new threads for this as well.

Further replies, please post here:

http://www.sqlservercentral.com/Forums/Topic1285914-391-1.aspx

Sounds like you are not calling the stored proc then because the temp table in the proc is

#Orderstastics

Either that, or you have an error within the proc that you corrected...

charles-1011021 (4/18/2012)

---

I know this was 6 years ago, but I am having the same problem today. Did anyone ever come up with an answer? I have tried saving...

How are you calling the stored procedure from SSRS?

One of the things I do differently than you (and since they work on my end), is to list out the columns...