locked
Possible to fill 2 Date field parameters in Report Builder by selecting item in dropdown? RRS feed

  • Question

  • User390268857 posted

    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.

    Ann

    Wednesday, June 28, 2017 2:42 PM

All replies

  • User390268857 posted

    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 seen here.

    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.

    Wednesday, June 28, 2017 4:51 PM