title: How can I filter on different dates based on the value of parameters
body: <p>In SSRS, is it possible to display different date field results based on a parameter value?
  Here is the requirement: There is a parameter called status (values: open, closed, pending) which filters result based on a status field. if open is chosen then all the open loans will display if pending then all the pending loan records will be displayed. Each status has its own date column. In report, user will first select a status (either open, closed or pending), then the date parameter will filter on  date field depending on what is selected. So if user selects open status then date field will filter on open date field. If closed is selected then date filter will filter on closed date and so on. I know cascading parameter functionality will be used but I am really confused on how to allow date filter to filter on a specific status date (based on what status value is chosen).</p>