Forum Discussion
Fliter dataset
I try that one it is not working. It shows data of way back like 01/01/2025 i have lot of data into dataset but it is not returing data what i expect. I am doing matrix table date at column and order number at row and total order vaule in matrix. i expect to get data for last 9 days.
then pls update your sample data and expected output
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