ssrs-2008
Duplicated 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 rows in ssrs writing expression not by grouping.
You need to create groups. If you have some way that your summary rows from the dataset are linked to specific data rows, then you should group on that.
Or you could group on the "Row Type" column. Keep the formula you are currently using for detail row visibility, and use the group header to toggle visibility. You can hide the group header for your summary rows using a visibility formula with the logical inverse of your current formula. This will it visible for the detail rows.
Yes On a group you cannot set the column visibility directly. However you can go to advanced options then set the hidden property and set it to true or false or expression. If you want to shrink the table then set column shrink true.
hope it helps
Best Answer
You probably should try these options first:
If not, on the row's Visibility Hidden property you can use the Previous function:
You would have to sort on the YourField column for it to work.