topic Re: In Report Builder Concatenate multiple records in one row in Report Server

In Report Builder Concatenate multiple records in one row

Cervo114 — Wed, 05 Jun 2024 14:23:15 GMT

Hi, In PowerBi Report Builder, i need to concatenate multiple records in one row, which function can I use? Thank's in advance

Re: In Report Builder Concatenate multiple records in one row

Anonymous — Thu, 06 Jun 2024 01:12:34 GMT

Hi Cervo114 ,

Combine more than one field by using concatenation operators and Visual Basic constants. The following expression returns two fields, each on a separate line in the same text box:

=Fields!FirstName.Value & vbCrLf & Fields!LastName.Value

The following link will help you:

Expression examples in Power BI Report Builder - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: In Report Builder Concatenate multiple records in one row

Cervo114 — Thu, 06 Jun 2024 14:06:04 GMT

My need is to group multiple records in a single row Example: I have some clockings, one at 09:00 am and one at 12:00 am, which are in two different records, my need is to print them in a single line next to each other. I hope I was clear

Re: In Report Builder Concatenate multiple records in one row

Anonymous — Thu, 18 Jul 2024 07:57:40 GMT

Hi Cervo114 ,

Please provide the rdl for us.Thank you

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.