I have a .rdl with multiple parameter year that the user can select. I run a stored procedure that return all data but as soon as I put a filter in my dataset it returns no data.
The parameter year is not parsed to my stored procedure. It is only used with the filter.
Why doesn't it work?
Please please help. Thanks
I did do that. But thanks for the advice. It works fine until I put the filter in. If no filter, then all my data returns. With filter, nothing. E.G. when all data is returned I can see data for 2011, 2012. As soon as I add the filter on parameters - 2011, 2012 then no data.