A unique request from customer...they would like have the report parameterized where they can select a date from a dropdown, but when they open the report, they do not want to select anything from the parameter dropdown; i.e, they want the report to open and already show the data for the most recent date by default, then if they are interested in seeing a date from the past, only then do they want to use the parameter and select a date. Is it even possible to be able to provide both capabilities? if so, how? I can just create two separate reports for the user, i.e, one defaulting to the most recent date, and another one that is parameter driven, but trying to avoid this.
I defaulted the report to show the maximum date and keep the parameter, but it always opens empty and prompts me to select a value in the parameter dropdown