Only distinct values from the sql data source to standalone telerik report designer

[Jayraj]

I have one table in sql server and I am fetching it in standalone report designer using stored procedure but I need distinct values to be displayed only.

Is there a method in standalone report designer to show only distinct values because I can't do it in sql server for some reasons.

 

Thank you in advance.

[Todor]

Hi Jayraj,

You may try the built-in Aggregate Functions we provide. For example, AllDistinctValues returns an array containing only the distinct values evaluated from the Expression you pass as a first argument.

Another option may be to use Report Groups. In the group header/footer you may display the distinct grouping value.

Regards,
Todor
Progress Telerik

[Jayraj]

I tried AllDistinctValues but not able to get the desired result.

Instead I found the easier solution: using Previous(expression)=expression in conditional formatting.