topic Comma-separated expression in Report Server

Comma-separated expression

mrslyfox911 — Mon, 01 May 2023 12:04:23 GMT

Hello,

I need expression for my PowerBI Paginated report.
Dataset name: RequestedInstances

Field 1: Instance

Field 2: Count_Instances

I need a comma-separated list of all values 'Instance'

For the current expression, I have an error:

The 'Value' expression for the text box 'Textbox22' refers directly to the field 'Instance' without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions which specify a dataset scope.

Expression: =Join(Fields!Instance.Value, ", ")

Re: Comma-separated expression

mrslyfox911 — Mon, 01 May 2023 21:15:05 GMT

report header allows only static data, for that reason workaround was applied to the dataset

Re: Comma-separated expression

M_nwadibia — Tue, 02 May 2023 16:22:03 GMT

Can you try this. What this does is to add comma separator to 2 or more digit number but keeps single digits as they are

IIf(Len(CStr(Fields!Column_Name.Value))>1, Join(Split(CStr(Fields!Column_Name.Value),""),","), CStr(Fields!Column_Name.Value))