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

How can i implement parameterised and filtered report using stored procedure in Telerik reporting.

1 Answer 75 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jackson John
Top achievements
Rank 1
Jackson John asked on 01 May 2010, 08:23 AM

HI!

      I am new to telerik reporting , I want to implement a report using stored procedure with 5 filters on the report to get the desired out put. So, please can any one explain me how can i do it? or any link to see the video for the same?

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 05 May 2010, 02:43 PM
Hi Jackson John,

You can connect to a SQL Server database using the Telerik SqlDataSource component. 

In Telerik Reporting, you can filter report data before or after it is retrieved for a report. When you filter data in the query, you filter data at the data source, which reduces the amount data that needs to be retrieved and processed in a report. To filter data after it is retrieved, create filter expressions in the report. You can set filter expressions for a data item, or a group, including detail groups.

Filters can contain report parameters in filter expressions, providing a way to filter data for specific values or for specific users, for example, filtering on a value that identifies the user viewing the report. Filters are defined using the the Edit Filter Dialog.

For more information check out the following links:

How to: Connect to a SQL Server Database Using Stored Procedure
What's New in RadControls for WinForms & Telerik Reporting in Q1 2010
Filtering Data

Sincerely yours,
Peter
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Jackson John
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or