Parameter grouping and reports with multiple parameters

While we won't cover this in detail, I would like to discuss it briefly. With reports, one can create multiple report parameters and bind them to a single dataset or to multiple datasets. Just because a parameter has already been bound once does not mean it cannot be bound again. When we create a report parameter, that parameter becomes a global variable for our report that can be used anywhere in the report. We can also use multiple parameters in a single dataset, both as prepared parameters for queries and filters. For example, let's say we have a query that pulls all orders for a particular market and for a date range. In this query, we would have three parameters—one for the market, and two for the start date and end date. Each of these can be set to a data set parameter and a report parameter.

So, what happens when we start to have more parameters and need to manage them? The simple answer is that we can create a parameter group...