Filter in report

8 posts, 0 answers
  1. Shaikh
    Shaikh avatar
    2 posts
    Member since:
    Jun 2011

    Posted 02 Jun 2011 Link to this post

    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.
  2. Peter
    Admin
    Peter avatar
    1631 posts

    Posted 02 Jun 2011 Link to this post

    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
  3. Shaikh
    Shaikh avatar
    2 posts
    Member since:
    Jun 2011

    Posted 02 Jun 2011 Link to this post

    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
  4. Stephan
    Admin
    Stephan avatar
    12 posts

    Posted 06 Jun 2011 Link to this post

    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
  5. Jitendra
    Jitendra avatar
    4 posts
    Member since:
    Sep 2012

    Posted 10 Sep 2012 Link to this post

    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
  6. Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 14 Sep 2012 Link to this post

    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 >

  7. Siddharth
    Siddharth avatar
    2 posts
    Member since:
    Dec 2013

    Posted 27 Dec 2013 Link to this post

    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







  8. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 27 Dec 2013 Link to this post

    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
Back to Top