Last Updated: 08 Jan 2021 13:08 by ADMIN
Created on: 20 Dec 2020 18:01
Type: Feature Request
Access a field from another Data Source component
It is not possible to directly access multiple data sources using expressions in a single section or object. I would like to be able to define multiple data sources on a report and then bind textboxes to the data sources using a formula such as "=First("DataSourceName","FieldName")", which would bind to field FieldName in the first record of datasource DataSourceName, regardless of the datasource assigned to the table, list, etc.  We should be able to reference fields from multiple datasources in a single table, at least when using aggregates that return one value, such as Min, Max, First, Last, Sum, etc.
Posted on: 08 Jan 2021 13:08

Hello Albert,

Thank you for the valuable addition. Well explained. Will have that in mind when brainstorming the implementation.

Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Posted on: 03 Jan 2021 02:53
A function "DataExec(datasource,aggregateFunction)" would be perfect for this and seems to fit with the Telerik architecture.  This function would allow access to alternate data sources with a different scope from the current data item.  As an aggregate function it would always return one value so this would be a scalar function, similar to PageExec in that regard.  When this function was called, if the specified datasource was not initialized then it should be initialized at that time, calling NeedDataSource, etc.  Then the aggregate would be calculated and returned.  Example syntax might be =DataExec("objectDataSource2",First(Fields.ContactPhone).  The DataExec function should be callable from any section in the report, including Page Headers/Footers.