Approved
Last Updated: 10 Jan 2019 09:49 by ADMIN
Jonathan
Created on: 26 Jun 2018 13:45
Type: Feature Request
6
add new function: LOOKUP() (similar to SSRS)
This function would allow you to lookup a value from another data source with a value that is in your current data source.  It would return the first matching value for the specified name from a data source that contains name/value pairs.

This would allow the porting of many SSRS reports over to Telerik Reporting.

Example: 

I have a report which lists all sales staff in our firm, with other personal information. We have a multi-dimensional data source (Cube) where we have all the financial data stored and calculated. 

If I wanted to retrieve the total sales and total revenue that each member of the sales staff had, it would require me to use a sub-report to load the data (using a parameter to pass the staff member's unique ID).  

This causes the loading/generating of the report to take longer, as the query against the Cube has to happen for each member of the sales staff, because of the use of a sub-report. With this new LOOKUP() function, it would allow the data source to be loaded and the report would be able to lookup the sales and revenue values for each staff member ID.
4 comments
ADMIN
Silviya
Posted on: 10 Jan 2019 09:49
Hello Mykhaylo and Jonathan,

Mykhaylo, thank you for your input, we will consider this scenario during the implementation.

Jonathan: Unfortunately, I cannot name the exact date when the task will be in development. All tasks are sorted based on multiple criteria such as demand, severity, available and required resources etc.
Alternatively, you can follow the feature request to check if the status is changed to 'In Development' and also our release history page for release notes.
 
Regards,
Silviya
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Mykhaylo
Posted on: 09 Jan 2019 15:58
Another possible usage of Lookup: translation of report resources. All translations as text resources are stored in a database and returned in a corresponding dataset for current user Locale. I need a formula to be inserted in each Label Value in a report to get translated value from translations dataset. Lookup("CurrentResourceAlias",Fields.Alias.Value,Fields.Text.Value,"ReportResourcesDataset").
Jonathan
Posted on: 28 Sep 2018 12:39
Milen,

Do you know when this functionality might be added?
ADMIN
Milen
Posted on: 12 Sep 2018 16:56
Thank you for your request.