What version of SSRS are you using? I don't have an InitialToggleItem Property on a row in a table using 2005.

I am attaching a report that uses a Parameter...

What is the behavior you are seeing in Report Manager?

While not perfect try using the IsNumeric Function, check out the BOL Entry for it. So your query could be this:

SELECT

CONVERT(decimal(5,2),value)

from

...

In 2005 yes, but in 2008 you can use C# as well. My current work place is...

I'd never considered copyright issues when googling code, getting scripts from sites like SSC or blogs, or posting code to SSC, on my blog, or to the SQL Server Code...

Lynn Pettis (4/17/2009)

---

Sounds like you could have used the SNOW DAY. I was dressed and my tie half tied when I got the call this morning. It has...

Which is why I...

bruce.trimpop (4/17/2009)

---

GSquared (4/17/2009)

---

I can't imagine a single other professional field where people would actually defend the practice of "we don't do it right, because we can't be bothered to learn...

Like we all haven't done the same thing a hundred times. That's what the extra set of eyes is for.

Thanks for the kind works guys.

I don't know that "Brilliant" should be used, but I'll take it. 😀

You could have the first step in your SSIS package Drop all the FK's and then finish the package with a step that re-applies them.

Well if the code you posted is the exact code you used then your problem is that you are missing the '@' sign before OutPutFileName in the sp_trace_create call here's...

I changed your expression to use Switch which I think is easier to read and it looks okay to me:

=Switch(Parameters!Report_Parameter_AR.Value = "" AND Parameters!Report_Parameter_State.Value = "", False,

Fields!AR.Value = Parameters!Report_Parameter_AR.Value...

I'd just get rid of the filter that filters out Profiler. That is just there so that the Profiler GUI doesn't trace it's own activity. That will eliminate...

You need to use either a table or list control. I am attaching a simple example using a table and the AdventureWorks database.

Basically I created a group on the...