locked
Include null values in report in addition to those matching the SSRS parameter RRS feed

  • Question

  • Hi

    In SSRS I am using report builder (no code being used)

    In the report I am using a simple parameter that filters the dataset for dates after a certain date in a grouped query with a sum of values etc.

    =Parameters!AfterDate.Value

    In addition to any parameter applied I also wish to retrieve null values in the date field in other words if I select 14/7/2014 then the retrieval needs to include all dates after that but also to include any items with null values in the date field.

    I have tried ticking the parameter ’allow null’ box but was not sure how to adjust the report filter.

    I’m not sure whether the issue is to do with the parameter or the filter.

    The dataset before the report parameter etc includes the null values fine

    Any assistance appreciated.

    Brian


    Brian Hyam


    • Edited by Brian Hyam Monday, August 4, 2014 2:55 PM
    Monday, August 4, 2014 11:26 AM