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

Filtering data using date report parameter

1 Answer 452 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
James
Top achievements
Rank 1
Iron
James asked on 11 Apr 2019, 05:18 PM

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.

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 16 Apr 2019, 04:19 PM
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
Tags
Report Designer (standalone)
Asked by
James
Top achievements
Rank 1
Iron
Answers by
Neli
Telerik team
Share this question
or