Filter in report

[Shaikh]

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.

[Peter]

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:

• Grouping, Sorting, and Filtering in Telerik Reports
• Filtering Data
• How-To: Add filtering to Report

Kind regards,
Peter
the Telerik team

[Shaikh]

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

[Stephan]

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

[Jitendra]

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

[Chavdar]

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

[Siddharth]

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

[KS]

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