0

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"), ",")

Mohammed Ameen
  • 139
  • 2
  • 10
  • Have a look at this similar question https://stackoverflow.com/questions/27047483/ssrs-distinct-lookupset-function – Alan Schofield Apr 05 '22 at 12:50
  • The link given by Alan seems promising. Personally I'd just change the data source's query to perform grouping there if possible. – HardcoreGamer Apr 07 '22 at 06:43

0 Answers0