Databand linked to another databand via common relation

Stimulsoft Reports.NET discussion
Post Reply
fortiaBA
Posts: 17
Joined: Fri Jan 20, 2023 4:26 pm

Databand linked to another databand via common relation

Post by fortiaBA »

Dear community,

Here is our 2 entities
Slide1.PNG
Slide1.PNG (9.01 KiB) Viewed 845 times
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.
Slide2.PNG
Slide2.PNG (9.08 KiB) Viewed 845 times
We can't get it to work with Data Relation and Master Component, is there a way to do it ?

Best regards,

fortia team
ulli82
Posts: 47
Joined: Tue Jul 06, 2021 6:46 am

Re: Databand linked to another databand via common relation

Post by ulli82 »

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
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Databand linked to another databand via common relation

Post by Lech Kulikowski »

Hello,

Thank you for the suggestion.
fortiaBA
Posts: 17
Joined: Fri Jan 20, 2023 4:26 pm

Re: Databand linked to another databand via common relation

Post by fortiaBA »

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" ?
ulli82
Posts: 47
Joined: Tue Jul 06, 2021 6:46 am

Re: Databand linked to another databand via common relation

Post by ulli82 »

You need both. Master Component will not work without a relation.
fortiaBA
Posts: 17
Joined: Fri Jan 20, 2023 4:26 pm

Re: Databand linked to another databand via common relation

Post by fortiaBA »

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 ?
ulli82
Posts: 47
Joined: Tue Jul 06, 2021 6:46 am

Re: Databand linked to another databand via common relation

Post by ulli82 »

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
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Databand linked to another databand via common relation

Post by Lech Kulikowski »

Hello,

Perhaps, you need to use the HierarchicalBand component.

Thank you.
Post Reply