Report Builder And/Or Parameters

dkilpat · ‎04-13-2023

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 month.

Sample data:

Invoice #	Create Date	Paid Date
S001	1/15/2023	2/15/2023
S002	2/10/2023	4/2/2023
S003	2/11/2023	3/5/2023
S004	3/5/2023	3/15/2023
S005	3/8/2023
S006	4/10/2023

They need to be able to select parameters for the Create Date start and end as well as the Paid Date start and end. An example would be for the month of March. Create Date parameters would be 3/1/2023 to 3/31/2023 and the Paid Date Parameters would be 3/1/2023 to 3/31/2023. We want the report to return Invoices S003, S004 and S005.

I have been able to get the parament range to work for one or the other or both together, but am having trouble getting it set for OR.

Please help. Thank you in advance.

Jon-Heide · ‎04-19-2023

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-pa...

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