1
1
The perfect solution for creating powerful yet inexpensive business solutions by integrating data from multiple SharePoint lists. Enesys RS Data Extension lets you leverage all the power of Microsoft SQL Server Reporting Services with your SharePoint Data.

Knowledge Base and Samples

How can I have a new line for the multi-value custom separator so that each value appears in its own row?

The best approach to achieve this result is to use a report's expression that will replace the default separator with a new line char.

By default, values in a multi-value column are separated by a comma. When displaying such a column in a report you will obtain something similar to what is shown in the following screen shot.

Multi-value column using default comma separator

In order to replace the comma by a new line, use the following expression instead of using the column directly in your layout:

Enter a report's expression instead of using the column directly Enter the following expression in order to replace the comma separator with a new line char

Your report will be displayed like shown in the following screen shot:

Multi-value column with each value in its own row

Note that if you need more fine grained control over each value layout, an alternative approach would be to use the "expand Multi-values" feature.