Last post Jun 28, 2017 04:51 PM by aterrell
Jun 28, 2017 02:42 PM|aterrell|LINK
I am migrating an old Access data maintenance form into an SSRS report. I'm trying to determine whether it is possible to mimic all of the form's functionality in SSRS (or not).
I'm pretty new at SSRS but at first look it doesn't appear easy or even possible to do.
The old form has several buttons that when clicked fills in 2 date fields (see screenshots). Can this be done in SSRS? If so, what do i want to look at? Cascading parameters?
Here is the old form and the
new version mockup.
Thanks for any guidance you can provide.
Jun 28, 2017 04:51 PM|aterrell|LINK
I've found a solution, which probably should have been obvious.
For the dropdown that allows the user to choose "quick date ranges" on the SSRS report parameters, I created the dropdowns to use specified values, as
Then, on the date range parameters, I
specified values with expressions for both label and value to switch between the defined values in the "quick dates" dropdown.
Now I just need to put the actual dates into a dataset instead of hard-coding the dates.