I am new to CR and am having trouble creating a comma delimited string in the report header. In the details of the report I have numerous records with YEAR as the point of interest. I would like to make a list of all the distinct YEARs and then present them in the report header as a comma delimited string. It is important that following the last entry there isn't a comma. It could also mean that there is a YEAR missing which is ok, depends on the records.
ie 2008, 2009, 2010, 2011, 2013
I would like to use this same logic with a list of AUTHORS for a particular publication. I would like to put the AUTHORS in a comma delimited string in the report header and in their order of authorship.
ie Brown, Jones, Smith where Brown is author 1, Jones author 2 and Smith author 3
I would also like to use this logic for distinct DEPARTMENTS for a particular report. I would like to put the DEPARTMENTS in a comma delimited string in the report header.
ie BSTU, STHY, QUESR, DYTU (They could be order by their location in the report.
Any ideas