I tried attaching a screenshot of the report.

This belongs in SSRS 2008, so I will move topic to that forum.

The Facility parameter label, in a text box, shows correctly (value of 3 equals a specific Facility.Label, which is Facility Name, that is setup for the specific values in the...

The data type of the Facility parameter is INT. The field values of Field1 and Field2 are numeric with 2 decimal places.

I even tried the following, for a check to...

All in all, upon lots of digging, I was able to find 3 records that were causing the problem. Two of the records had a dash, so trying to grab...

Unfortunately, I am not working in a SQL Server 2012 environment to use try_parse. I did run the suggested script to break apart the Year, Month, and Day, and did...

In your WHERE clause, you could try:

WHERE DATEPART(dw, getdate()) in (2, 3, 4, 5, 6)

That should give you only weekdays.

While in and of itself, that statement suggested works fine, but when I try to put it into a CASE statement, it is still failing. That field I am trying...

That worked!! That expression was written by a previous developer, and I was trying to modify it to get rid of the divide by zero error that would occur. I...

Yeah, I am running into an issue with a divide by zero error with the following:

=replace(round(((Sum(CDec(Fields!Field1.Value)))/(Sum(CDec(Fields!Field2.Value)))*100),2), "NaN", "0.00")+"%"

I tried to add an IIf statement, but I get an error stating...

I got it to go by adding CDec to the expression as follows:

=replace(round(((Sum(CDec(Fields!FIELD1.Value)))/(Sum(CDec(Fields!FIELD2.Value)))*100),2), "NaN", "0.00")+"%"

Gotta love expressions!!

For the Text Box Properties > Number, it is listed under the Category of Percentage with 2 Decimal Places.

I got it resolved. I forgot to remove the * from the end of the query that I was building, so I am not sure what it was that was...

That worked. I changed my CASE statement to look like the following:

case when ISNUMERIC(SRESULT) = 1 then

CASE WHEN CONVERT(int, SRESULT) between 0 and 500 THEN '2' --Green

ELSE '0'

END

It is now...

I was able to work through the issue, and can now get all of the rows to be inserted. The file that I was trying to import did not take...