How to Add Tag with Merge OR Hide Property in Report.

If user want to hide some repeated text in front of other column the use the column Property Processing Duplicates also use the Tag from Interaction Property.

To apply the effect on report using the below steps:

1. Open a new report and create a data-source, and create a relation in between 2 tables. (Here I am using 2 tables “InvProduct” and “InvProductGroup”).
2. The report create without using Group. Drag the required column in Data band.
3. The data comes as the below image, the common values displayed multiple times, and if user want to hide or merge the recurrence data. (See Image 1).

Figure 1 Interaction Property

4. Now to hide the duplicate data from the Product Group column.
5. Select the data column > Go to Processing Duplicates > set the property Hide based on tag or Merge based on tag as per requirement.

Figure 2 Interaction Property

6. Now select the next property Interaction > Tag and in the left panel put the column based on the duplicate values should be changed.

Figure 3 Interaction

7. See the report in preview the data will be displayed in the below format

8. Now use the Merge based tag to apply on the column.

9. See the report in preview the data will be displayed in the below format.