In Telerik Reporting it is possible to access the data Fields after they have been rendered on the page. This could be done in the page header or footer sections since their Item expressions are evaluated after paging has finished, as explained in the Report Life Cycle
For example, if you need all the distinct items from a specific group that have been rendered on the current page, I could suggest you to use the AllDistinctValues
aggregate function (more on aggregate functions could be read here
), evaluated in the scope of the particular group (indicated with its name, i.e. "groupName
") as arguments of the PageExec
function, i.e. 'PageExec("groupName
))'. This function would return all the distinct Fields.fieldNameOrSomeExpression
of the "groupName
" groups that have been rendered on that page. Note that even if only part of the group is rendered on the page, the entire group of values would be returned.
The collection of values returned by the PageExec
could then be passed as an argument of a custom user function that could use them in the desired way. How to extend expressions with User Functions is explained here
. Note that it would be necessary to extend the Standalone designer with the assembly of the User function, as explained in this
article. The configuration file of the Standalone designer that should be modified is named Telerik.ReportDesigner.exe.config
and could be found in (Telerik Reporting installation folder
)\Report Designer (for example C:\Program Files (x86)\Progress\Telerik Reporting R3 2017\Report Designer) folder. The assembly itself should be copied to the same folder. The properly added User Function would appear under the Edit Expression Wizard->Functions->Misc->(The Class of the function
I have prepared a sample report that uses such a user function to display all distinct 'name' fields that have been rendered on each page. The appropriate list of names is displayed on each page header. The Report, the Assembly, and the C# code of the Function could be found in the attached .zip file. The Assembly should be copied to the Standalone designer folder, and the designer config file should be modified as explained above.
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?
Telerik Feedback Portal
and vote to affect the priority of the items