Database Reference
In-Depth Information
WHERE
E.DateTime >= DATEADD(d, -30, GETUTCDATE())
AND E.EventLevelId = @EventLevel
ORDER BY
3 DESC, 6 ASC, 5 ASC
10. When prompted to
Enter Data Source Credentials
, select
Use the current Win-
dows user
or type the password for the service account and click on
OK
.
11. Notice the
@EventLevel
placeholder we used in the query we just added to our
dataset. Report Builder automatically created a corresponding report parameter to
allow the event level to pass to our report. Expand the
Parameters
node in Re-
port Builder and make sure that the
EventLevel
parameter has been added. As we
do not want the report consumer to pass free text in the parameter, we will restrict
the available values for this parameter to the event levels returned by the shared
dataset created earlier in this recipe.
12. Right-click on
Datasets
and click on
Add Dataset…
.
13. Enter
PSEventLevels
as the name and select the
Use a shared dataset
option.
Click on
Browse…
and browse to the location where you saved the
Event Levels
shared dataset. Click on
OK
.
14. In the
Parameters
node, right-click on the
EventLevel
parameter and click on
Parameter Properties
.
15. Under
General
, change
Data type
to
Integer
.
16. Under
Available Values
, select
Get values from a query
. Under
Dataset:
, select
the
PSEventLevels
dataset. Under
Value field
, select
EventLevelId
. Under
La-
bel field
, select
EventLevelTitle
. Click on
OK
, as shown in the following
screenshot: