If I understood correctly, you want to use a filtered SQL data source
in the report. If so, this filtering can be done from the Wizard while the data source is being added. Basically, the addition of it is like before (Data -> SQL DataSource -> add the data connection -> choose the connection location), but the statement should be specified in the Stored Procedure
option. Check the attached screenshot. More information can be found at Selecting Data with the SqlDataSource component
If you would like to combine the results of two or more queries or Stored Procedures in a single data source, you may consider using an ObjectDataSource component
. Basically, this data source invokes a method (Data Member) of a class/type (Data Source) that is supposed to return the data to be used in the report.
For complex calculations in a report that cannot be done with our built-in functions
, you may use custom user functions
, where you may define custom logic performing the necessary processing.
You may consider also opening a support ticket where to provide more details about the particular scenario and a sample runnable report (including some dummy data). This will give us more insights into the problem and we may come up with more specific pieces of advice.
Editing the content of an already sent message can be done by an admin, so if would like it changed, please, specify the new thread title in your next message and we will do it for you.
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