I'm trying to figure out the mechanics of an existing report created some time ago.
The report contains two datasets. One provides the user with a single batch ID to select as the parameter. The other dataset has a query that hits the relevant database tables but the query doesn't contain ANY parameter evaluation in the WHERE clause.
How is it that SSRS is combining the batch ID parameter with other query?