So after much MUCH research and digging into this report i'm developing, i've figured out that there is a problem with the report i've deployed. My stored proc is working perfectly. I put in the parameters that i would put in to get certian data and i get that data back. However, my report is not behaving the same. For example one of the parameters is Rep, and when i put in All reps but the last one, i get the results i expect, however when i put in the last rep its not giving me back my results. The issue is, that when i do the same thing for just the stored proc, i don't have this issue. I get the results whether that last rep is in there or not. Also i thought it may have been a cached report issue, so i even deleted the report and re-deployed it, but that didn't fix it either. Is this something i'm going to have to completely just delete the original .rdl file and create a new report from scratch? Or is this a bug that's come up before? I'm using SSRS 2008 the server is also 2008, but has R2 installed. (not sure if this could be a problem)

Could you run the profiler and make sure the parameters passed are correct ? There may be scenario your parameter lenghth is less than the value passed the value will be automatically truncated.

I've not used profiler before. I've got it up, i'm just not sure how to run it. I can't find a good "How To" example on the web. Am i running this on the report? or the stored proc the report is hitting?

Ok so i've run the profiler and it's definitely passing in the correct data to the stored proc. Where do i go from here?

After running the profiler i figured out that the last value of one of the parameters had a space on the end which was screwing up the stored proc. Seems to be working great now.