Yes, you need to pass the parameter to a method in the ObjectContext/DbContext
class and this is the only way to filter on the database level.
You can define a variety of such methods according to the data that needs to be retrieved or just a single method which can return the different data based on the passed arguments. Then you can map the EntityDataSource
component parameters to report parameters and if you need the data differently you would need to change only the report parameters. Please check the Retrieving data from an Entity Data Model with the EntityDataSource component
help article which outlines the approach, but note that you can build on top of that to achieve more complicated data retrieval scenarios.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.