This is a migrated thread and some comments may be shown as answers.

Sorting and filtering is back end or front end process

3 Answers 722 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Nithin
Top achievements
Rank 1
Nithin asked on 29 Jun 2018, 05:08 AM

Hi,

We are developing Telerik report using the stand-alone designer, so we need to know about how the sorting and filtering are done in Telerik reporting. Is it a backend or frontend process.?

3 Answers, 1 is accepted

Sort by
0
Silviya
Telerik team
answered on 03 Jul 2018, 02:47 PM
Hi Nithin,

There are two ways to achieve filtering and sorting:
client-side: Filters and Sortings are applied to the data set after it is retrieved by the DataSource. It should be avoided for big data. 
server-side: The recommended approach, i.e. to filter and/or sort data records before they are retrieved by the DataSource component, using the WHERE/ORDER BY clause in the query.
For more information, check Filter DataSource records ("Server side" filtering vs "Client side" filtering) and Ordering Data help articles.


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
0
Nithin
Top achievements
Rank 1
answered on 04 Jul 2018, 01:41 PM
What does mean by client-side sorting? How can we achieve client-side sorting?  Sorting via Action is this client-side or server-side sorting? Also please provide an example of client-side sorting.
0
Nasko
Telerik team
answered on 04 Jul 2018, 02:12 PM
Hello Nithin,

Client-side when talking about Telerik Reporting means that the data is sorted/filtered by the Reporting engine after it has been retrieved from the data source. This is done by setting a new sorting/filtering rule to the data item:
var sorting1 = new Telerik.Reporting.Sorting();
sorting1.Expression = "=Fields.ProductID";
sorting1.Direction = Telerik.Reporting.SortDirection.Asc;
report1.Sortings.Add(sorting1);

Server-side on the other hand means that the data is sorted by the data source provider and the Reporting engine receives it already sorted. This is best shown when using SQL server and sorting the data on the SQL server by using a ORDER BY clause. Same with filtering and the WHERE clause.

Sorting via action is performed client-side when considering the definition explained above.

Regards,
Nasko
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
Tags
Report Designer (standalone)
Asked by
Nithin
Top achievements
Rank 1
Answers by
Silviya
Telerik team
Nithin
Top achievements
Rank 1
Nasko
Telerik team
Share this question
or