RichardM140
Programmer
Hi,
I reviewed several discussion on this site about default value for date parameters, but I haven't found the answer I've been looking for yet.
I have a date range parameter and I would like to default the "Start of Range" value to CurrentDate minus 7 and the "End Of Range" value to CurrentDate. Then of course the user can change the values to fit their needs if necessary. The problem is that I need the default values to display when the parameter prompt is displayed.
I've seen a couple examples where I place an out of scope date like 1/1/1800, and then programmatically change the dates if the values have not been changed. Which I could do by capturing the min & max values, but the user still sees the 1/1/1800 in the parameter prompt. The values are only corrected on the report, so users find this confusing.
So basically is there away to adjust the displayed parameter values that the user sees in parameter prompts?
Thanks in advance for any advice.
Richard
I reviewed several discussion on this site about default value for date parameters, but I haven't found the answer I've been looking for yet.
I have a date range parameter and I would like to default the "Start of Range" value to CurrentDate minus 7 and the "End Of Range" value to CurrentDate. Then of course the user can change the values to fit their needs if necessary. The problem is that I need the default values to display when the parameter prompt is displayed.
I've seen a couple examples where I place an out of scope date like 1/1/1800, and then programmatically change the dates if the values have not been changed. Which I could do by capturing the min & max values, but the user still sees the 1/1/1800 in the parameter prompt. The values are only corrected on the report, so users find this confusing.
So basically is there away to adjust the displayed parameter values that the user sees in parameter prompts?
Thanks in advance for any advice.
Richard