SSRS and hiding other selections once a parameter is selected

Posted by KristiLee on Stack Overflow See other posts from Stack Overflow or by KristiLee
Published on 2010-04-05T16:53:34Z Indexed on 2010/04/05 17:03 UTC
Read the original article Hit count: 270

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

© Stack Overflow or respective owner

Related posts about ssrs-2005

Related posts about reportingservices-2005