I have never used the OVER function before. I had to do a bit of reading to understand the question. I learned about a useful, but limited, function....

First I can't imagine that many rows (unsummarized) having any useful value, it is simply too much data to look through.

Second, what is the sort expression you are using?

I will frequently forget to add the .value in the expression builder the first time through.:-)

try this

=IIF(ReportItems!textbox27.value ="X","Green","Black")

Can you execute the stored procedure with the same parameters from the query designer in SSRS without crashing? If it works OK there, you might try to limit your...

dcase 42479 (11/3/2010)

---

Ok. I have two expressions that return a sum for me.

#1 =SUM(IIF(Fields!Work_Center.Value="34 MAZAK",1,0))

#2 =SUM(IIF(Fields!Work_Center.Value="34 MAZAK" AND Fields!Operation_Status.Value="O",1,0))

Instead of having yet a third expression I would like to...

Sure, you should be able to build a data driven subscription that only returns email addresses when the report dataset meets certain criteria as you suggest.

If you can't touch or modify your query, you can concatenate the fields using the expression builder in SSRS.

What happens when you run the SP with the exact same parameters in management studio? If it runs, look for bad data.

Frequently when there is no report delivered, people assume that there was a problem with the report rather than there was nothing to report. I would suggest an alternative...

tosscrosby (11/3/2010)

---

Me too....Although, I did hook up with an "old" friend last evening. She is gorgeous.....and at my age! So maybe this morning isn't so bad...

Good question. Thanks to VK to pointing out the Char issue (reinforcing what I know.....but frequently forget).

floodgate

Good question, and very good follow up discussion. Thanks to all.

So they don't care if the rest of the number is random?

1234

1243

1299

1257

1201

What is the point? Why not just sort by the whole field?

1204

1234

1243

1257

1299

It is still the same data, and...