Hide duplicate row SSRS 2008 R2 RRS feed

  • Question

  • User88744855 posted

    duplicate data is coming in my report because source table has duplicate data. without creating group i want to hide duplicate data writing expression. so what i did...i select table row and put a expression for hidden property of table row.

    the expression was like =(Previous(Fields!ID.Value) = Fields!ID.Value) but it did not work...still duplicate data is showing. so tell me how to suppress duplicate row in ssrs writing expression not by grouping. thanks

    Friday, March 16, 2012 9:54 AM

All replies

  • User306743125 posted
    Hi, it would be better to exclude the duplication from your data set by modifying you select statement. Post your query if you need help.
    Saturday, March 17, 2012 2:39 AM