I've got a requirement to produce a series of reports that are exactly the same thing apart from they would be based on differnet date ranges.
For example, I've got to produce Previous Month, Previous Quater , Previous Year and Current Year to Date but also another where they can enter whatever dates they like.
Now rather than having 5 reports to maintian I want a single report with a drop down list from where the user can select which range they want.
If it were the just the predefined options I would pass the selected option back to the underlying stored procedure and let SQL Server determine the range but it doesn't work well for the custom range.
I thought about having the From and To date parmeters available in the report and pass both the selected option AND the From/To dates into my Stored Procedure but ignore the From/To unless they've passed back the "Custom Range" option.
But there are a couple of things I really don't like about that; first of all the From/To dates are always on show in the parameters bar and secondly I do like to display the values of the parameters set when I render the report.
I know for the second part I could display two different fields dependant on the selected option but if I can just get the drop down list to populate the From/To parameters then it feels like a more straightforward solution.
Ideally I'd like the Selected Option to populate the From and To parameters in the SSRS header.
Failing that I'd like the Selected Option to determine the visibility of the From/To parameters.
Perhaps there's an alternative I've not considered...
Any help really appreciated.