Search
Search

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

Shell D Published at Dev
23
Shell D

In MS SQL Server Report Builder 3.0, I have an SSRS report with 3 parameters:

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

    My Stored Procedure needs either a Date Range OR the last number of days, not all 3 (they are set to NULL by default).

    I want to be able to toggle a parameters NULL checkbox (tick/untick) based on the value of another parameter, eg: last # days has NULL ticked, then untick NULL checkboxes for the date range (start & end date) & vice versa. Any ideas on how to do this please?

    Thanks in advance.

    • Tab Alleman

    The checkbox for a parameter to allow NULLs can only be set at design-time. You can't have it checked/unchecked depending on other parameters or user action.

    The only way to handle your requirement is to allow all three parameters to be NULL, and have your stored procedure return an error message when the user doesn't meet at least one of the required conditions.

    Collected from the Internet

    Please contact [email protected] to delete if infringement.

    edited at
    0

    Comments

    0 comments
    Login to comment

    Related

    From Dev

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

    From Dev

    Value of parameters is null

    From Dev

    Creating checkboxes in userform depending on parameters

    From Dev

    SimpleJdbcCall parameters not inserting null as NULL value

    From Dev

    SSRS Report Parameter Default Null Value not Applied

    From Dev

    The parameters dictionary contains a null entry for parameter Orderid

    From Dev

    How to cover a void method that avoids null parameters by passing a null parameter?

    From Dev

    SSRS automatic extension columns depending on the parameters - tablix

    From Dev

    SSRS automatic extension columns depending on the parameters - tablix

    From Dev

    How to select values for parameters in SSRS based on a previous parameter's selection?

    From Dev

    Flexible search with parameters return null value

    From Dev

    Java Ajax request parameters have null value

    From Dev

    Flexible search with parameters return null value

    From Dev

    MDX Query with parameters with multiples values and null value

    From Dev

    Null check value types passed via parameters

    From Dev

    How to move null to a checkbox in SSRS

    From Dev

    Blank Parameter to Null Parameter in SSRS

    From Dev

    Blank Parameter to Null Parameter in SSRS

    From Dev

    Multi Value Parameter in SSRS -Values are showing NUll when selected

    From Dev

    Linq with null parameters not working

    From Dev

    Prepared Statement with Null Parameters

    From Dev

    NULL parameters on Class instantiation

    From Dev

    MVC Route Parameters Are Null

    From Dev

    NULL parameters on Class instantiation

    From Dev

    Assign NULL to parameters in method

    From Dev

    Query SQLite with parameters null

    From Dev

    stored procedure String parameter returns null for some parameters

    From Dev

    How to set, as default template parameter, a nested template class instanciation depending on other parameters

    From Dev

    SSRS parameters dynamically passed to other reports

    Related Related

    1. 1

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

    2. 2

      Value of parameters is null

    3. 3

      Creating checkboxes in userform depending on parameters

    4. 4

      SimpleJdbcCall parameters not inserting null as NULL value

    5. 5

      SSRS Report Parameter Default Null Value not Applied

    6. 6

      The parameters dictionary contains a null entry for parameter Orderid

    7. 7

      How to cover a void method that avoids null parameters by passing a null parameter?

    8. 8

      SSRS automatic extension columns depending on the parameters - tablix

    9. 9

      SSRS automatic extension columns depending on the parameters - tablix

    10. 10

      How to select values for parameters in SSRS based on a previous parameter's selection?

    11. 11

      Flexible search with parameters return null value

    12. 12

      Java Ajax request parameters have null value

    13. 13

      Flexible search with parameters return null value

    14. 14

      MDX Query with parameters with multiples values and null value

    15. 15

      Null check value types passed via parameters

    16. 16

      How to move null to a checkbox in SSRS

    17. 17

      Blank Parameter to Null Parameter in SSRS

    18. 18

      Blank Parameter to Null Parameter in SSRS

    19. 19

      Multi Value Parameter in SSRS -Values are showing NUll when selected

    20. 20

      Linq with null parameters not working

    21. 21

      Prepared Statement with Null Parameters

    22. 22

      NULL parameters on Class instantiation

    23. 23

      MVC Route Parameters Are Null

    24. 24

      NULL parameters on Class instantiation

    25. 25

      Assign NULL to parameters in method

    26. 26

      Query SQLite with parameters null

    27. 27

      stored procedure String parameter returns null for some parameters

    28. 28

      How to set, as default template parameter, a nested template class instanciation depending on other parameters

    29. 29

      SSRS parameters dynamically passed to other reports

    HotTag

    Archive