reporting services - SSRS Parameters - Toggle a parameter's NULL checkbox depending on value other parameter(s) NULL checkboxes -


in ms sql server report builder 3.0, have ssrs report 3 parameters:

  • start date (date)
  • end date (date)
  • last number of days (integer)

    my stored procedure needs either date range or last number of days, not 3 (they set null default).

    i want able toggle parameters null checkbox (tick/untick) based on value of parameter, eg: last # days has null ticked, untick null checkboxes date range (start & end date) & vice versa. ideas on how please?

    thanks in advance.

  • the checkbox parameter allow nulls can set @ design-time. can't have checked/unchecked depending on other parameters or user action.

    the way handle requirement allow 3 parameters null, , have stored procedure return error message when user doesn't meet @ least 1 of required conditions.


    Comments