I belive that's as rare as the heffalump

I just had the same problem today.

The short answer is SSRS cannot get a good hold on the results of the procedure (my interpretation of SSRS-speak). You're using temp...

another option is

... where field < (2 + parameter)

the downside to using this type of calculation is

* the logic isn't as straight-forward. So other folks looking at...

If it helps (misery loves company): I've never been more frustrated with one single program in my life more than SSIS.

Anyway, when I've had issues with parameters as you're having,...

Thanks for your thoughts, guys.

I like the more English-like style, myself. To me it just seems easier to read.

One option is:

SELECT [Fname] + ' ' + ISNULL([middle] + ' ', '') + [Lname] AS fullname

Sounds reasonable. Thanks!