When ‘Merge duplicates’ (Duplicates = Duplicates.Merge) is enabled for a TextObject, the text field itself displays only the common string for a group of identical values. To display the number of original rows for this merged value alongside it, use grouping:
Add a GroupHeaderBand above your DataBand (the grouping condition should be the same field used to merge the text, for example [Items.Category]).
Place the merged field and the counter on the GroupHeaderBand or GroupFooterBand, or create a Total field in the Data window
Comments
Hello!
When ‘Merge duplicates’ (Duplicates = Duplicates.Merge) is enabled for a TextObject, the text field itself displays only the common string for a group of identical values. To display the number of original rows for this merged value alongside it, use grouping:
Add a GroupHeaderBand above your DataBand (the grouping condition should be the same field used to merge the text, for example [Items.Category]).
Place the merged field and the counter on the GroupHeaderBand or GroupFooterBand, or create a Total field in the Data window