Join tables together based on an ID.

1 Answer 373 Views
General Discussions Report Designer (standalone)
Michael
Top achievements
Rank 1
Iron
Iron
Michael asked on 10 Jun 2021, 08:50 PM
I have multiple tables that I would like to join together based on e.g. CustomerID. I know I could use a report parameter, which I already am using for the date. What I want to do is filter by the date report parameter, but align the table rows by the Customer ID in each table so it looks like a seamless report. Can I do this through binding?? If so, how?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 15 Jun 2021, 01:01 PM

Hello Michael,

Do you mean to join multiple tables from the database and display the fetched joined data in a single data item? If so, you may use a proper SQL Query or Stored Procedure in the SqlDataSouce component associated with the corresponding data item.

If the requirement is to have several report tables populated independently with data and to align them based on the CustomerID, I'm afraid we don't support this out of the box. The reason is that each data item has its own data source and can access only it and the data sources of its parent items, for example, the report. The sibling data items cannot access each others' data sources. Therefore, it is not possible to compare fields from two sibling tables.

Note that you may use Report Groups and display the data grouped, for example, based on the CustomerID value.

If the above doesn't answer your questions, consider opening a support ticket and elaborating on the scenario, for example, with sample data and a sample report.

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
General Discussions Report Designer (standalone)
Asked by
Michael
Top achievements
Rank 1
Iron
Iron
Answers by
Todor
Telerik team
Share this question
or