List a set of fields into a table cell

[mcantos]

Hello, 

I'm working on a paginated report and I need to display in a column a list of fields inside. For instance, in column 2 I need to list a set of fields, each item belongs to a specific field in the dataset. Is that possible? 

Thank you so much in advance. 

[mcantos]

Hi @v-xiandat-msft ,

Thank you for taking the time to reply. It worked!  

I only replaced the blank spaces with a line break for the alignment to be more precise. 

=First(Fields!Status.Value, "DataSet1") & Chr(10)
&First(Fields!Opportunity_name.Value, "DataSet1") & Chr(10)
& First(Fields!Owner_name.Value, "DataSet1")

Best regards,

[v-xiandat-msft · Accepted solution]

Hi @mcantos ,

Below is my table1:

Below is my table2:

The following Expression will might help you:

=First(Fields!Field2.Value, "DataSet1") &"                     "
&First(Fields!Field3.Value, "DataSet1") &"                   "
& First(Fields!Field4.Value, "DataSet1")

The final output is shown in the following figure:

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.