Apply Kendo UI Grid Filter to Telerik Report

[Brian]

I have a Kendo UI grid with filters. I want to take those filters and apply them to a Reporting Services report. How do I pass the filters from the UI Grid to the reports end point?

I've seen plenty examples of how to do this with the RadGrid, but not with the UI JS grid.​

Note, I'm using the DataSourceRequest helpers to construct linq queries. I'd prefer to keep this using these helpers.

 

 

thanks

[Stef]

Hi Brian,

Reports are processed and rendered entirely on the server. Thus data must be submitted to the server and obtained from there. If you are working with data service, test the approach illustrated in Connecting Telerik Reporting to OData feeds.
In case you want to modify the report before displaying it in a viewer, you can use a custom report resolver for the Reporting REST service.


I hope this information is helpful.

Regards,
Stef
Telerik

[Brian]

That's not what I'm asking. 

What I'm asking is, how to pass the Gird Filters to a Reporting Services end point. Can the telerik report endpoint accept a parameter? 

The filters I'm passing must be a DataSourceRequest object.

[Stef]

Hello Brian,

The HTML5 Viewer is a client-side widget which requests are handled and served by a running instance of the Reporting REST service. Thus on a request for a report, it is processed and rendered in the selected format on the server. The client(viewer) gets only the rendered document.

To display a report the viewer sends a request with string description of the report that has to be resolved on the server. This resolving occurs in the service's report resolver (the default resolvers or a custom one), where the only information that is posted to the resolver is the string description of the report.

Thus if you want to get the filters settings from a grid widget and use them to create filters for the report you can:

1. Design the report in such manner that data can be filtered on data retrieval based on report parameters - "Server side" filtering. Then it is enough to gather information about the grid filters at the client and pass this information as values for the report parameters. To update the report parameters of the displayed report, you need to update the viewer's reportSource - How To: Pass Values to Report Parameters.
2. Gather information about the grid filters and post it back to the server, where the information must be stored. Then this information can be accessed:
   1. In the report or other data item's NeedDataSource event. Thus the filters information can be used to filter the report's data - Using Report Events;
   2. In a custom resolver used by the Reporting REST service. Thus you will have the filters information in the resolver's Resolve method allowing you to modify the report instance before displaying it in a viewer.

In order to provide you more accurate suggestions, please elaborate on the scenario:

• What data is displayed by the grid widget and how data is supplied in it?
• What data is displayed by the report and how data is supplied in it?
• What is the purpose of obtaining the grid filters and their usage in reports?

Regards,
Stef
Telerik