I am very glad to hear it's working for you!
If I understand correctly, you are saying if the target report's data doesn't contain the date you selected, that date won't be selected in the target report.
I believe that this is the expected behavior, unfortunately. A possible workaround might be to add a missing value for every day (or month, etc depending on your format) in the target data source. Using SAS DATA step code or SQL syntax in your data preparation stage, it should be reasonably simple to do this with some sort of loop.
If you did that workaround, the correct date should be displayed in the target report's date prompt but of course no data would be displayed in the objects.
A much simpler workaround would be to set a less precise format on the date (quarter instead of month, month instead of day), but that causes a lot of changes you might not want.
Thanks,
Sam
... View more