Suppress duplicate group values, SSRS reports

Question

I have an SSRS report where the date should be grouped by project category, the project code in the category is repeated in the group side, how can I suppress the value

Please help me get an idea.

Thanks brijit

Answer 1

You can also hide fields by placing the expression in the Hidden property as follows:

=Fields!ProductCode.Value = Previous(Fields!ProductCode.Value)

So, if the value in the previous record matches this value, it will hide the field. You must correctly sort the dataset for this to work. In your case, I believe the sorting will be Date, ProductCategory, ProductCode.

, .

Answer 2

, ssrs. . . , , . , , , .

Answer 3

brijt, , :

=IIf(Fields!ProductCode.Value = Previous(Fields!ProductCode.Value), "White", "Black")

... , , .

Answer 4

I think this may be a problem with how you group the dates. Do you have over time grouped on them, but an overwhelming output clock?

For example:

12-5-2010 12:00:00

12-5-2010 13:00:00

if you turn off the time in the way you see them, but cannot group them, they will appear cheated.