<div>
What is your database type?
</div>


<div>
I cannot help with Oracle. However if you search for &quot;return comma separated values&quot; you might find the right syntax and create a SLQExpression to get this data. This will allow you to avoid using subreport.<br />
<br />
The other way ( with subreport) - you need to create a &quot;whileprinting&quot; formula &nbsp;with a shared variable and append the department to the shared variable (in the details section ).
</div>


I cannot help with Oracle. However if you search for "return comma separated values" you might find the right syntax and create a SLQExpression to get this data. This will allow you to avoid using subreport.

The other way ( with subreport) - you need to create a "whileprinting" formula  with a shared variable and append the department to the shared variable (in the details section ).

<div>
<div class="content wysiwyg-content">
I have a subreport where multiple rows can be returned for a &nbsp;department_id which is passed from the main report.<br />
<br />
I have the department name in the detail section of the subreport.<br />
<br />
What I would like to do, is each time a row is read concatenate the department name seperated by commas for example:<br />
DepartmentA, DepartmentB, DepartmentC....<br />
instead of<br />
DepartmentA<br />
DepartmentB<br />
DepartmentC
</div>
</div>


I have a subreport where multiple rows can be returned for a  department_id which is passed from the main report.

I have the department name in the detail section of the subreport.

What I would like to do, is each time a row is read concatenate the department name seperated by commas for example:
DepartmentA, DepartmentB, DepartmentC....
instead of
DepartmentA
DepartmentB
DepartmentC

Crystal 2011 CONCATENATE rows' 'value INTO ONE STRING within a subreport

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.