The report retrieves information for 2 periods as comparatives such as year 2017 & 2018.
In Design mode it works perfectly that is I can change different periods and Jet works fine, However when in Viewer Mode, as soon as I change the dates Jet changes the dates again as when I was using Designer Mode. I cannot understand what I am doing wrong as in an other report I created it is working fine.
Any assistance please? greatly appreciated. How can I attach the report so that you can see.