Implement interactive date range control
-
In Step 1 of the Request Wizard select, for example, the Page report.
-
Next to the Commonly Used Dates drop down, click the Control Settings icon:
-
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.
-
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.
-
Click OK. The control appears in the cell location that you specified:
-
You can now change the date range and the request will refresh with that date range.
-
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.
-