Stimulsoft Business Intelligence System | Forum

Dear community,

Here is our 2 entities We have a databand Meeting. We want to show below a list of previous meetings that would be linked to the same location.
So we want to configure another databand to would show the list of meetings with the same location.
We can't get it to work with Data Relation and Master Component, is there a way to do it ?

Best regards,

fortia team

You can use a 3rd, intermediate databand for location.

Databand1(Meeting) -> link to Databand2(Location) -> link to Databand3(Meeting).

Databand2 do not show any information (height = 0).
On Databand3 you have to filter out the current meeting of Databand1

Hello,

Thank you for the suggestion.

ulli82 wrote: ↑Wed May 31, 2023 12:53 pm You can use a 3rd, intermediate databand for location.

Databand1(Meeting) -> link to Databand2(Location) -> link to Databand3(Meeting).

Databand2 do not show any information (height = 0).
On Databand3 you have to filter out the current meeting of Databand1

Hello thank you for the suggestion,

What do you mean by "link to databand..." ? Do you refer to "master component" or "data relation" ?

You need both. Master Component will not work without a relation.

ulli82 wrote: ↑Thu Jun 01, 2023 9:52 am You need both. Master Component will not work without a relation.

Hello,

Thank you for your answer

I have a little problem, my entity "meeting" is linked to the entity "location" with a relation 0 to 1, "a meeting has one location" and "a location has multiple meetings".
That's why, i can't link the databand2 (location) to the databand3 (meeting), i haven't got the option in the data relation parameter.

Do you have an idea how to proceed ?

I can't understand your problem. Can you explain it in more detail please?

Because this is the normal use case of master-detail reports: one instance with 1 or more related sub-instances.

Databand1: Source = Meeting
Databand2: Source = Location, Relation = Link from Location to Meeting, Master = Databand1
Databnad3: Source = Meeting, Relation = Link from Meeting to Location, Master = Databand2

Hello,

Perhaps, you need to use the HierarchicalBand component.

Thank you.