I have a parameter (dropdown menu) on my report which will filter or sort the data depending on the chosen option. There are only 2 options to choose from in this dropdown.
I want to Hide duplicates for when the user selects option 1 but not to hide the duplicates for when option 2 is chosen. Since the "Containing group or dataset" field has an expression option next to it, I assume you are able to put in an expression for which dataset to use. The expression I try is along the lines of:
=iif(Parameters !Filter.Value = 1, DATASET1, Nothing)
This throws back this type of error:
[rsInvalidHideDu plicateScope] The value ‘=iif(Parameter s!Filter.Value = 1, DATASET1, Nothing)’ of the HideDuplicates property of the textbox ‘Textbox1’ is invalid. This value is the name of a group or data set over which to apply the hiding: it should either be the name of a group containing the current group or, to hide duplicates over the entire data set, the name of the current data set.
Anybody have any ideas on correct expressions which can be input into this field? Thanks in advance.
I want to Hide duplicates for when the user selects option 1 but not to hide the duplicates for when option 2 is chosen. Since the "Containing group or dataset" field has an expression option next to it, I assume you are able to put in an expression for which dataset to use. The expression I try is along the lines of:
=iif(Parameters !Filter.Value = 1, DATASET1, Nothing)
This throws back this type of error:
[rsInvalidHideDu plicateScope] The value ‘=iif(Parameter s!Filter.Value = 1, DATASET1, Nothing)’ of the HideDuplicates property of the textbox ‘Textbox1’ is invalid. This value is the name of a group or data set over which to apply the hiding: it should either be the name of a group containing the current group or, to hide duplicates over the entire data set, the name of the current data set.
Anybody have any ideas on correct expressions which can be input into this field? Thanks in advance.
Comment