sql - Local SSRS Report Execution is Caching Dynamic Variable, Even After Deleting .rdl.data -

i have report i've deployed ssrs, each month, meant generate report of results previous month.

i begin dynamically generating variables determine month/year generate report results :

declare @reportingmonth int set @reportingmonth = month(getdate()) - 1   declare @reportingyear int set @reportingyear = year(dateadd(month,-1,getdate())) 

then, in clause filter results month(datecolumn) = @reportingmonth , year(datecolumn) = @reportingyear

the first month ran report october, results 9-2016. include field in use

cast(@reportingmonth nvarchar)+'-'+cast(@reportingyear nvarchar) [report period] 

to verify results. ran report again locally, , since november, @reportingmonth should = 10. @reportingmonth still set = 9 however. copy/pasted data source query directly ssms check hadn't made error, , no - when query executed directly, results return 10-2016.

i've seen weird caching results happen local runs of reports in ssrs before, , deleting .rdl.data file, re-running had solved sort of thing in past. tried multiple times here no luck.

where else ssrs caching these variables based on first month's run?

i had issues ssrs cash too. code solved go tools>> external tools>>