or
I have two tables, one with the header Name, and the other showing the projects associated with each name. I want the Name table to show only one value for name, with all corresponding projects listed in the 2nd table. However, where there is more than one project per name there will be that many duplicate names, which I don't want.
It seems that this might normally be solved by grouping, however if I group these table values together I get repeating table-headers that I don't want also.
So is it possible to prevent duplicate data in an expression, rather than grouping? Where my current expression for the name is:
= Fields.[Name]
...these are my pseudo-code ideas for expressions to solve this:
= Fields.[Name] DISTINCT
= Fields.[Name] WHERE Fields.[Name] <> Previous(Fields.[Name])