I am wanting to filter my report based on Fiscal Year. I have the first parameter as @STARTDATE and 2nd parameter as @ENDDATE. The values for both of these are hardcoded in non queried. When the user selects the @STARTDATE , I want to automatically
set the value for the @ENDDATE parameter. I'm doing it this way because I'm using BETWEEEN in my SQL Query. Ideally, I will just have the @ENDDATE value hidden if possible.
So for example:
@STARTDATE has values of 10/1/2009 and 10/1/2010.
@ENDDATE has values of 9/30/2010 and 9/30/2011.
When @STARTDATE is selected to 10/1/2009, set the @ENDDATE value to 9/30/2010.
When @STARTDATE is selected to 10/1/2010, set the @ENDDATE value to 9/30/2011.
Any idea how/if this can be accomplished?
View Complete Post