Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dkilpat
Regular Visitor

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

 

Sample data:

Invoice #Create DatePaid Date
S0011/15/20232/15/2023
S0022/10/20234/2/2023
S0032/11/20233/5/2023
S0043/5/20233/15/2023
S0053/8/2023 
S0064/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.

1 REPLY 1
Jon-Heide
Employee
Employee

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.