Geek Answers Handbook

Hide Duplicate String SSRS 2008 R2

Duplicate data comes into my report because the source table has duplicate data. Without creating a group, I want to hide the duplicate expression of the data record. So what I did: I select the table row and put the expression for the hidden property of the table row.

The expression was like = (Previous (Fields! ID.Value) = Fields! ID.Value) but it didn’t work ... While repeating data is repeated. So tell me how to suppress duplicate strings in ssrs by writing expression, not grouping.

+5
source share
5 answers

You should probably try these options first:

  • Try to clear duplicate data in the source.
  • , . (, SELECT DISTINCT)

, Previous:

=iif(Fields!YourField.Value = Previous(Fields!YourField.Value), True, False)

YourField, .

+11

, " " . , . . , , , , , . , , , .

+6

" " .

:

=IIF(Fields!YourField.Value = Previous(Fields!YourField.Value), True, False)

:

  • F4 .
  • " "
  • DataSet

, ,

+3

, . , , Hide Duplicates - .

, , ( Row Group, Group Properties) Group expressions General. , . " " Microsoft Excel

+1

Hide Duplicates . =Sum(Field!Field_Name.Value) sum around, . , , , NULL .

0

More articles:


All Articles