Filtering data using date report parameter

2 posts, 0 answers
  1. James
    James avatar
    12 posts
    Member since:
    Mar 2019

    Posted 11 Apr Link to this post

    My report pulls 6 months, on the first to the last day for each month, of data from the past using a data picker and will use all 6 for one of the graphs, but I also want to use only the last full month of data for all of the rest of the graphs so I need to filter the 6 months to get that data.  I am trying to filter only the data for the last month using the date from the parameter but for this I will need the date parts because I want from the first day of the month to the last day of the month.  Can someone please give me an idea how I can do this?

    ie.

    Date Picker chooses 3/5/2019 meaning getting data for all days in each month of Oct, Nov, Dec, Jan, Feb, Mar

    One report uses all 6 months

    All other reports use only data from March

    Any help would be greatly appreciated.

  2. Neli
    Admin
    Neli avatar
    82 posts

    Posted 16 Apr Link to this post

    Hello James,

    The attached report demonstrated the following approach: 
    A CSV data source which contains dates from October 2018 to March 2019 is used. The Report Parameter is DateTime.
    The Graph displays only the data for the month of the selected date. The following filter should be added for this purpose to the Graph :

    Expression: =Fields.Date.Month
    Operator: =
    Value: = Parameters.DateParameter.Value.Month

    More information for Graph filtering can be found at How to: Add filtering to Graph item article.

    Regards,
    Neli
    Progress Telerik
    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
Back to Top