Forum Discussion
Fliter dataset
- 1 year ago
update the file . pls kindly reivew
here is data
Filter date which is single select date, this is from the table
Here is my dataset where i want to fliter for last 9 days whenver they select date.
order date item number price
1 03/03/2025 1 50
2 03/04/2025 2 60
3 03/03/2025 3 70
4 03/04/2025 4 80
5 03/06/2025 6 90
6 02/01/2025 7 90
when i select 03/06/2025 i want to go all back with -9 order date it ilike paramter in SSRS to get filter from dataset from selected date all backward to 9 days
i am doing matrix
Item number 02/26/2025 .......03/03/2025 03/04/2025 03/05/2025 03/06/2025
1 0 50 0 0 0
2 0 0 60 0 0
3 0 70 0 0 0
4 0 0 80 0 0
5 0 0 0 0 90
in this we should notget 02/02/2025 date at all which is not < 9 days
pls see the attachment below