Implement interactive date range control

  1. In Step 1 of the Request Wizard select, for example, the Page report.

  2. Next to the Commonly Used Dates drop down, click the Control Settings icon:

    Screenshot of the Request Wizard Step 1 highlighting the Control Settings icon.

  3. In the Control Settings dialog, select all the date range items that you want displayed in the interactive control. In addition, specify the upper left cell location of the control.

    Screenshot showing the selected date ranage items and the upper-left cell location.

  4. Notice the option to “Automatically refresh linked requests upon item selection”.

    • If checked, all requests that use this control are refreshed.
    • If not checked, the associated request parameters are updated, but the request is not refreshed.
  5. Click OK. The control appears in the cell location that you specified:

  6. You can now change the date range and the request will refresh with that date range.

    Screenshot showing the selected date range.

  7. You can also copy the request and right click to use one of two Paste Request options:

    • Paste Request > Use Absolute Input Cell. This means that the copied request will point to the same interactive date range control as the original request.

    • Paste Request> Use Relative input Cell. This mean that the copied request will point to its own control.

      NOTE
      You can use the native Microsoft Excel Cut/Copy/Paste control functionality. Report builder automatically recognizes the newly added controls.