I have a rolling matrix report that displays a rolling year worth of data. Problem is, I'm pulling in months PRIOR to when the report is supposed to start. Can anyone identify why my expression will not correctly display my month/year in my report. Funny thing is, I can display month OR year, just not both. What am I missing?sytax? thanks = "SELECT * FROM vw_SummaryRpt WHERE Month(" & Parameters!TimeSlicer.Value & ") IN (" & Join(Parameters!Month.Value,",")& ")" & " AND Year(" & Parameters!TimeSlicer.Value & ") IN (" & Parameters!Year.Value & "," & Parameters!Year.Value -1 & ")" MY month/year are grouped by rows...

How are you selecting your months. If you pick pick month 3 of 2011 then I assume you want 04/2010 through 03/2011. It finds 03 in the month value and then 2010 (year - 1) in the year and now you have selected 03/2010 which is outside the range you want. Change the where so that data year/month >= selected year-1/selected month+1 and data year/month <= selected year/selected month 201012 >= 201004 and <= 201103 data will be included 201003 < 201004 data will be excluded

Hi mnico, Is the issue solved by JHab’s method? I suppose that he’s suggestion could help you resolve the problem. If the issue still exists, could you please supply more details about it, such as data structure, how to get the values for the parameters TimeSlicer, Year and Month, or incorrectly data which you have got. Those information is a big help for us to help you further. If you have any question, please feel free to ask. Thanks, Eileen Zhao