How does 'refresh schedule before execution' in CRD 5 works? There is an option to check this. I have noticed that whenever I check it, the record selection gets deleted afterward - I believe it is deleted everytime it is refreshed. How can I make the record selection stay after refreshing the schedule? (what I really want is to refresh the report, not the schedule).
According to the help file, when you make a change in the source report, the change is NOT reflected in CRD automatically. If you want the change to be pulled into CRD, then you use the "Refresh Schedule" option either by right-clicking and selecting "Refresh" or by using the automated option that you have discovered. If you have set up specfic record selection formulae within CRD, then this will, of course, be overwritten when you refresh the schedule and tell CRD to go an re-read everything from the source report.
If you simply want the latest data to be read everytime the schedule executes, you need do nothing, cause CRD does that automatically.