The Prompt property, however, controls the text the user will see on
the report next to the drop-down list. Therefore, this prompt could be changed from
Category to Product Category, for example, to help make it more clear. Beneath the
Prompt textbox are a number of check boxes, and one that is checked by default
when building a parameter in Reporting Services against a cube source is the Multivalue
check box. Unchecking this particular box changes the parameter drop-down
box so that users can make only a single selection from the list. Allowing only a
single selection removes the (Select All) option from the list, but the All Products
element will still exist, since the query generated for parameters includes the All
member by default.
In some cases businesses may decide not to have the All member in the list. This
is most often done with parameters that allow multiple selections, because having
both the (Select All) option and then an all members item is confusing for end users.
Getting rid of the All member is a matter of modifying the query that was created
when the Parameters check box was clicked. Remember that one of the things
that will happen when you click the Parameters check box is the creation of a new
dataset to fill the parameter list. You can see this new dataset by clicking on the
Data tab and then looking at the Dataset list. The dataset will have the same name
as the default name of the parameter. After selecting the query, notice that it creates
a number of columns, such as ParameterCaption and ParameterValue.
Pages:
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421