none
Either or parameters and SSRS 2008

    Question

  • I have an (either or) situation in regards to parameters in SSRS 2008. I currently have my report working with a date range but I've been asked to add a drop down for the user to select the weekending date. I've got that drop down working but how can I switch between parameters (Date Range and the use of the Weekending Date drop down) for sending parameters to my report?

    Thursday, December 29, 2011 9:37 PM

Answers

  • Hi

    If you are using a query in your dataset then you can simply use the "OR" condition.  Something like below.

     where

           (

        YourDateField between @StartDate and @Enddate 

    OR YourWeekendDateField = @WeekendDate

            ) 

     

     


    regards Natraj www.BItipsntricks.com Please mark the replies as Answers if they helped!
    • Marked as answer by LDean Friday, December 30, 2011 3:05 PM
    Friday, December 30, 2011 11:29 AM

All replies

  • HI Friend,

    Can you let me the issue clearly.As far as I am understanding it seems that you have one set of parameter for date range selection and other for weekend dates only.

    Is that correct?

    Friday, December 30, 2011 4:44 AM
  • Hi

    If you are using a query in your dataset then you can simply use the "OR" condition.  Something like below.

     where

           (

        YourDateField between @StartDate and @Enddate 

    OR YourWeekendDateField = @WeekendDate

            ) 

     

     


    regards Natraj www.BItipsntricks.com Please mark the replies as Answers if they helped!
    • Marked as answer by LDean Friday, December 30, 2011 3:05 PM
    Friday, December 30, 2011 11:29 AM