Hi I have 2 parameters @begdate and @enddate.
When I select the @begdate ,I want @enddate to dynamically be set to the end of that current month.
I have @enddate default value as
=Format(DateSerial(Year(Parameters!BEGDATE.Value), Month(Parameters!BEGDATE.Value), "1").AddMonths(1).AddDays(-1),"MM/dd/yyyy")
It works the inital time of running the report, but when I change the @begdate to something else a second time the @enddate does not change with it.
I have come across this glitch before, for @enddate I over came it by setting the available value to the same as the default value. Also in report parameter properties/ advanced, change refresh data when parameter changes to always refresh.