A Telerik report is a template repeated for each record in the assigned to it data. You can use different data sources to feed the report and data items
in it, but using different data sources to supply data for a single data item's DataSource is not supported.
I can suggest you the following options:
- Create a data retrieval method that gathers the needed information into a single set of data, which has a tabular representation. For example use a SQL query which joins the tables logically and returns the needed records.
This approach allows you to use a single data source component to access the needed data;
- Use a separate data item (Table) for each set of records you want to display;
- Use custom functions in the report, which access data not related to the report's DataSource. This approach is not recommended due to the additional resources that will be used - Performance Considerations;
I hope the above information is helpful.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.