Forum Discussion

dkilpat's avatar
dkilpat
Regular Visitor
3 years ago

Report Builder And/Or Parameters

I need some help.  I am needing a way to set parameters for a paginated report that are an OR situation.  The example is a report that shows the invoices that were created or paid within a selected m...
Paginated Reports
parameters
report builder
Jon-Heide's avatar
Jon-Heide
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

You can create a filter expression for that. Or, alternately do that in your query. 

 

Add a filter to your table, and select the Fx button to add a custom filter expression. 

 

In your expression, create one which does the OR comparsion based on both dates and returnes True/False. You'll probably need to use IIF() and date functions to write the expression you need. Here's a few related examples to get you started. 

 

https://social.msdn.microsoft.com/Forums/Lync/en-US/8a72c3b9-c489-42e9-a9fb-baf1d6831f8b/ssrs-iif-parameter-date-logic?forum=sqlreportingservices 

https://stackoverflow.com/questions/37615404/ssrs-iif-date-format-less-than-a-specified-date 

https://social.technet.microsoft.com/wiki/contents/articles/32557.ssrs-date-time-expressions.aspx