Try running the stored proc in SSMS using WITH RECOMPILE. Sometimes RS gets hung because it's trying to use an old execution plan after the output of a proc...

Try putting the chart in a list control where the list control is bound to the offices. The chart should bind to each office's data as it loops through.

da-zero (9/20/2010)

---

In our environment they are against using stored procedures, for the simple reason that if you deploy your SSIS packages, you could forget to deploy your stored procedures. And...

I also favor sprocs wherever possible. Another advantage of sprocs is that you can check the task's output without having to open the package in BIDS. Otherwise, you...

A group footer using the territory as the scope should get you the sub-total rows. I've made reports with dynamic columns and that structure doesn't seem to interfere with...

You might be mixing data types. Try this:

=IIF(Fields!Product.Value = 98, " ", CStr(Fields!Product.Value))

A blank space can't be implicitly converted to an int.

Here's a guess (and it's only a guess): Enter all the search strings into one box -- e.g., "234, 121, 203, 119". That string gets passed to a...

I think dbowlin has a good solution. If the consumer is picky about appearances, you can add an empty group footer with no borders. The tablix will render like...

Go to the tablix properties and under the No Rows section, type whatever message you want to display in the NoRowsMessage property. This will hide the table completely and...

Thanks, Dan. That's good advice. I should add that I'm not thinking of leaving my job. Rather, I see this as an opportunity to learn an important...

More valuable, yes, but to whom? The only person you can truly count...

I passed the exam yesterday. The MS Press Training Kit was helpful but, for a number of questions, didn't go into enough detail to cover the actual exam questions. ...