Combining 2 datasource band

[meenakshikathiresan]

How to Group and Display Two Separate DataBands Side by Side?

I have two separate data sources, and each is displayed in its own DataBand.
Both data sources have a common column, groupId. I want to group the report by groupId and display the data from both DataBands side by side under each group.

Example:
Group 1
1. Data from Band 1 (Source 1)
2. Data from Band 2 (Source 2)

Group 2
1. Data from Band 1 (Source 1)
2. Data from Band 2 (Source 2)

I do not want to join the data sources. I also do not want to merge or join the data sources within the report.
The goal is to keep the data sources separate but group and display their data side by side for the same groupId. Is this possible?

[Lech Kulikowski]

Hello,

You can use Panels for this task:
https://demo.stimulsoft.com/#Net/Panels ... etailCards

Also, in this case, instead of grouping, you need to use source with all ids as the master.

Thank you.

[meenakshikathiresan]

Thank you for your response.

I’ve realized that there can be multiple matches for an ID, so displaying the data side by side doesn’t work as expected. Instead, is it possible to group the data in a way that interlaces them? For example, group 1’s data from Band 1 would be followed by group 1’s data from Band 2, and so on. This way, the data appears one after the other within the same group.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data for analysis.

Thank you.

[meenakshikathiresan]

I want to group both datasources together by GroupName.
Now I get listing from datasource 1 grouped by GroupName and followed by datasaource 2 grouped by GroupName.


I want to interlace them and get datasource 1 and datasource 2 for the same GroupName together and so on.

[Lech Kulikowski]

Hello,

Please send test data for your report.

Thank you.