'RDLC | TextBox Join distinct on Group

I have RDLC Tablix which has data below. My table is grouped by 1st column.

enter image description here

the red highlighted column shows the join value comma separated with respected to the 1st column. However there is repeating 1,1 in 1st row.

Main data set looks like something below enter image description here

Question:

  • How to avoid the repeating value in join statement. following is the textbox expression I have tried now

=Join(LookUpSet(Fields!Col1.Value, Fields!Col1.Value, Fields!Col3.Value, "DSName"), ",")

ssrs-2008rdlc


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions