I am currently filtering data on a report using wildcards which is the only way I know how to filter. The problem I am having is that when selecting period 1 the report is also pulling in data for periods 10,11 & 12. If I make this report filter to exact then I get no return on my report. Is there a better way to do this filter so when the parameter is put in it only returns the data for that period?
P.s apologies for asking so many questions at the moment, but I am self taught on SSRS using what I can from my excel knowledge which doesn't always work on SSRS