SSRS input parameters with null values trigger report itself

Question

when we have input parameters for stored procedures like @fromDate @toDate and both allow null values, when run the report it trigger itself and do not stop for user input. We have reports in crystal which not only shows parameters but also give user a opportunity to enter or check the checkbox for null value to pass. How could we achieve this SSRS?

nothing (null) but in st.proc. logic is if both null then fill back date one month and today. Full month period. — Builder

Riadhovic Riadhovic · Accepted Answer · 2018-02-02T14:52:38

You Can do this by checking the Allow null value option in the parameter propreties (General)

SSRS input parameters with null values trigger report itself

1 Answers