Jeff Moden (5/10/2012)

---

Didn't look to see if it was mentioned before but one sure fire way to increase the performance here would be to use UNION ALL instead of UNION....

Yes, that's correct. They are 2000. They will eventually be upgraded to 2008, but I am stuck working with this until that time.

Hmmm, ok. What about leaving the text box to the default and just doing the math with your fields? Does that error or give you a result (other than NAN...

Also, division by zero could give you an NAN. Try doing a conditional statement using something like this:

=IIF(Fields!YourData.Value > 0,Fields!YourData.Value/Fields!YourOtherData.Value),0)

You might need two statements if both of your fields can...

I definitely think the datatype could be preventing you from just setting the text box properties to percentage.

What's the datatype in that field? What does it look like? .0895? 1234? Let me know.

I didn't think you were trying to irritate me, Sean. To be faire, I did initially include most of the details you requested. I know that it's not easy to...

It's a direct query. I'm using it to create a report in SQL Server Reporting Services that will be posted to a report server.

I've tried one more thing (which is...

Ah, that clears things up (unfortunately).

Thanks for the info.

Yes, which is unfortunate. And it makes absolutely no sense, because the other set of claims tables are set up with just the 12 of the ID and indexed as...

Like I said, it's de-normalized. It has fields like ID, Value1, Value2, Value3...Value12, where Value should be in its own...

I'm confused. I did provide information. I'm not sure what else you need for my specific issue?

The part that I'm having issues with is passing a parameter with a wildcard...it's...

I've never encountered any issues with having the parameter with or without parenthesis.

The problem is that having the parameter all by itself will return the results without issue, but adding...

I had the EXACT same problem. I've got a main report off of a SQL server, and a subreport off of an Oracle server. After finally finding that SSRS needs...