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, and associate multiple parameters with that group. Therefore, in the example that we discussed in the earlier section , we can create a date range parameter group, and associate the "Start Date" and "End Date" parameters with it. This is as simple as dragging and dropping existing parameters in the Data Explorer or Outline tab, or creating new parameters inside of an existing parameter group.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset