By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,940 Members | 1,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,940 IT Pros & Developers. It's quick & easy.

Reporting Services Hide Duplicates Problem

P: 24
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:

[rsInvalidHideDuplicateScope] The value ‘=iif(Parameters!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.
Feb 29 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
I have not used SQL Reporting Services before. But if you're using some other application, I can only assume this is more of a front-end tool issue than a sql-server issue.

-- CK
Feb 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.