I have a daily revenue report (with 1 date parameter) that runs daily via report subscription. Is there a way to restrict the date parameter so it can only select from 2009/1/1 up to Yesterday. Our daily ETL process will process yesterday's data
around 6:00 am, if the user picks a wrong date then the report will be incomplete. I use =DateAdd("d",-1,Today()) for my default date parameter.
Is there a way to come up an explanation or a message that “processing has not completed” or “data not available” if the user try to pull a report with wrong date?
Thanks, Michael Mei
View Complete Post