Hello!
I need to filter my report by a date range. I have the Parameter and Filter setup within the build schema, screenshots below. However, when entering a start and end date then running the report, it is not filtering the report down to those dates. Thank you for the help!
Parameter:
Filters:
Report Parameters:
Best answer by lauraj46
Hi
The filter is probably not functioning as expected because of the “Or” operator on row 2 of the schema. Generally the OR operations should be inside of parenthesis, following a pattern similar to the screenshot below. Otherwise the default order of operations may return unexpecte results.
Also, I believe that the join between FSAppointment and FSServiceOrder should be on the SrvOrdType and the RefNbr.
Hope this helps!
Laura
+8Hi
Looks correct based on your screenshots. To debug, I would recommend printing the parameter values and the value of the FSAppointment.Execution date on the report. If you are still having issues, please post the rpx file on this thread and I will take a look.
Laura
Hi
Appreciate the help!
+8Hi
The filter is probably not functioning as expected because of the “Or” operator on row 2 of the schema. Generally the OR operations should be inside of parenthesis, following a pattern similar to the screenshot below. Otherwise the default order of operations may return unexpecte results.
Also, I believe that the join between FSAppointment and FSServiceOrder should be on the SrvOrdType and the RefNbr.
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
