2 thoughts on “Debugging Parameter Dependencies in Reporting Services

  1. I recently fought through this issue as well. In my case, one of the stored procedure parameters A) was unused and B) had a default value, so I removed that parameter from the stored procedure invocation. I suspect that SQL Server did something behind my back to “optimize” the call by removing the unused parameter.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s