Thanks for your answer. But I have some (additional) questions about your solution.
We have introduced some triggers in the document properties when opening the QV document and reloading the document. The action we performe are (next to jumping to the Dashboard sheet)
Jaar =year (LocalTime()) (sorry the variable names are in Dutch) and
Maandnr =num(Month (LocalTime()),'#0')
We reload the document every night before sending the PDF reports. But this didn't do the job. Can you explain why not?
However I did make a Bookmark of the start state (with the selections above) and applied it in the Report Settings as you recommended. It’s a pity that we have to wait till the month transition to ensure this adjustment to work. Although I’m not sure that I’ve made the correct Bookmark. Because you are talking about a function (=Month=month(today())) and I Bookmarked values. At least that’s what I think. I don’t know how to get the function in the selection except in this way.
So maybe that’s my next question for you if this doesn’t work.