Post reply

Two different date columns as parameters

  • August 26, 2016 at 4:10 am

    #400632

    i need to develop an ssrs report to be filtered by two different date columns and not all records have dates for both of the date columns..how to achieve that using report parameter,so that no records are missed?

  • August 26, 2016 at 4:43 am

    #1897746

    Brain fart. Will edit again in a bit.

    Edit: Answer number 2!

    Would this work. In the filter, add the following expression (replace with your paramter and date fields):

    =iif((Fields!date1.Value = Parameters!DateParam.Value) or (Fields!date2.Value = Parameters!DateParam.Value), 1, 0)

    Set the expression type as Integer, the Operator as = and the value as 1.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 26, 2016 at 5:02 am

    #1897747

    See new answer 😛 (yes double posted to get a subscription email off :P)

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 26, 2016 at 9:46 am

    #1897854

    Yes it worked..thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply