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

Filter in report

7 Answers 332 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Shaikh
Top achievements
Rank 1
Shaikh asked on 02 Jun 2011, 03:00 PM
Hi,

I need report which at first rendering report with data source. My data source is given below:

SELECT
        ,firstname
        ,lastname
        ,email
        ,amount
        ,madeon
        ,comments
    FROM
    [donor]
    INNER JOIN [transaction] ON transaction_pk = transaction_id

At first report is rendering using this data source. That mean user see all data in the report. Now  user want to filtering by firstname. So i need a text box which user is using to filter. User see all firstname in the report. So if user put any firstname in the text box then the report is filtering and report content is only containing the firstname  that user enter in the text box. we also need  two date parameter like start date and end date that maps to madeon. So contain will come in the report between start date and end date.


I need an example like this.
Please reply me as early as possible.

7 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 02 Jun 2011, 05:36 PM
Hello Shaikh,

To add filtering functionality to your report you can use report filter and Report Parameter. The Report Parameters add out of the box UI that corresponds to the report parameters type. Check out the following help articles that elaborate on the topic:
Kind regards,
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
0
Shaikh
Top achievements
Rank 1
answered on 02 Jun 2011, 08:05 PM
Hi Peter ,
I looked at your sample video but not finding exactly what i am looking for.

Basically i am trying to put a Text Box in Report designer so that i can search not by whole word but with any characters.
In referencing to demo, let's say i want to search by all product where category name contains 'co'. How that can be done?

I think for that you need a Text Box in designer. User key in 'CO' and hit preview to generate the report.

Do i need to do this programmatically?

If so, do you have an example for that.

Thanks
0
Stephan
Telerik team
answered on 06 Jun 2011, 04:17 PM
Hi Shaikh,

For your convenience we've created a small project that is attached here.

We add fields 'From Year', 'To Year' to set up the time interval and 'How To Search' combobox to choose how to use LIKE command. Search options are applied as they are described in topic Filtering Data in our Online Help. You can use LIKE with 'co%' if you want to get all products where category name starts with 'co', '%co' if the category name ends with 'co' or '%co%' if category name contains 'co'.

Don't hesitate to contact us again if we can assist you further.

All the best,
Stephan
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
0
Jitendra
Top achievements
Rank 1
answered on 10 Sep 2012, 01:21 PM
Hello Stephan,

I need to show filtering for date in below conditions on same report

Report Date ranges:     
today    
yesterday    
this week    
last week    
month to date     
last month    
year to date     
previous year     
quarter to date     
previous quarter     
custom period    

Can i place multiple filters ? how i can achieve this functionality.

Any help will be appreciated.

Thanks,
Jitendra
0
Chavdar
Telerik team
answered on 14 Sep 2012, 11:12 AM
Hi,

The best approach to achieve the desired functionality is to create your own user interface for selecting the date range. The report definition on the other side should have 2 hidden report parameters of type DateTime for the start and the end date. When the user selects a specific range, create the report, assign appropriate values for the report parameters and display the report in the viewer.

Hope this helps.

All the best,
Chavdar
the Telerik team

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

0
Siddharth
Top achievements
Rank 1
answered on 27 Dec 2013, 07:28 AM

I am facing a problem while creating multiple combo box filter



Up to a certain extent following link solved my problem



http://blogs.telerik.com/telerikreportingteam/posts/09-03-02/telerik-reporting-filtering-your-reports-using-report-parameters.aspx







But while selecting dates it gives me "missing or invalid parameter value, please input valid all parameters"







I don't have coding knowledge, I am only using telerick report designer to design my report, so I have used only Telerick editor



please help







0
KS
Top achievements
Rank 1
answered on 27 Dec 2013, 09:42 AM
The message appears as there is a report parameter without value, so set the report parameter's AllowNull to true and interpret the null value on the initial loading in the data retrieval implementation, or set default values in the designer or pass any value through the report source on showing the report. 

-KS
Tags
General Discussions
Asked by
Shaikh
Top achievements
Rank 1
Answers by
Peter
Telerik team
Shaikh
Top achievements
Rank 1
Stephan
Telerik team
Jitendra
Top achievements
Rank 1
Chavdar
Telerik team
Siddharth
Top achievements
Rank 1
KS
Top achievements
Rank 1
Share this question
or