Creating reports and dashboards | Stimulsoft community forum

Hi,
it seems that using the JoinColumnContent-function with a calculated column, that refers to a property of a referenced item, doesn't work.

I have the following structure:

The class GuestEvent has a property Person, that is also a class. This class has a property DisplayName. I want to join the DisplayName of the referenced persons of the list of GuestEvent-Items, but this doens't work:
{Func.EngineHelper.JoinColumnContent(GuestEvent, "Person.DisplayName", ", ")}

Then I tried to create a calculated column on the GuestEvent-class that refers to the Person.DisplayName-property. This works in a data band but not in the JoinColumnContent-function:
{Func.EngineHelper.JoinColumnContent(GuestEvent, "DisplayName", ", ")}
This produces an empty result.

How can I achieve this?

I am using Stimulsoft 2018.2.1.

Thanks,
Max

Hello,

Unfortunately, JoinColumnContent is not working via relation.

As a way, you can add an additional band, on which prepare joining Person for each GuestEvent in variable and then show that variable in the necessary Text component.

Thank you.

Hi,
thank you.

Perhaps you can help me achieve the following goal.
I have the attached data model. I have an event that has a list of persons connected through a relation (GuestEvent). Each person has a list of characteristics connected also through a relation.
I want to create a table with two columns. In the first column I have the name of the person (and some fields of the GuestEvent-relation, so I started to create a data band with the list of GuestEvents) and in the second column i want to have a list of characteristics of this person.

So I need to create for each GuestEvent item a string that contains all related characteristics of the connected person.

Thank you

Hello,

Could you send us a simple test data, we will try to find a solution for you.

Thank you.

Hi,
I have prepared a simple example report and a picture of what I try to get as report.

Thanks

Hello,

Please check the sample report in the attachment.

Thank you.

Perfect! Thank you very much!
Max

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.