Skip to Content
0
Former Member
Apr 04, 2014 at 01:53 AM

Comma delimited string in report header

113 Views

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