SSRS and hiding other selections once a parameter is selected
- by KristiLee
I am learning SSRS so this is probably an extremely easy solution. I have a bunch of reports that were rebuilt to match some old Access reports. For each report, we have to be able to run Current, Last, Next or Adhoc dates. Is there an easy way if a user selects Adhoc to then show the parameters selections for Start and End Date for the Adhoc selection? Right now, I have people who select Current and then go and put in dates.
WHERE (:AGNT='--AllNoFilter--' OR AGNT =:AGNT)
AND (:DateRunOption <> 'CM' OR TO_CHAR(MONTH_END_DT, 'Month YYYY') = TO_CHAR(CURRENT_DATE, 'Month YYYY'))
AND (:DateRunOption <> 'LM' OR TO_CHAR(MONTH_END_DT, 'Month YYYY') = TO_CHAR(ADD_MONTHS(CURRENT_DATE, -1), 'Month YYYY'))
AND (:DateRunOption <> 'AD' OR MONTH_END_DT>= :BeginDateFrom)
AND (:DateRunOption <> 'AD' OR MONTH_END_DT<= :BeginDateTo)
Thank you for any assistance you can provide