Can this be done in the Filter of a DataBand
Can this be done in the Filter of a DataBand
IIF
(
VAR_SortBy == "EmployeeID", DBA_Employee.EmployeeId>=VAR_Selection.From && DBA_Employee.EmployeeId>=VAR_Selection.To, DBA_Employee.EmployeeName>=VAR_Selection.From && DBA_Employee.EmployeeName>=VAR_Selection.To
)
(
VAR_SortBy == "EmployeeID", DBA_Employee.EmployeeId>=VAR_Selection.From && DBA_Employee.EmployeeId>=VAR_Selection.To, DBA_Employee.EmployeeName>=VAR_Selection.From && DBA_Employee.EmployeeName>=VAR_Selection.To
)
-
- Posts: 800
- Joined: Tue Sep 07, 2021 10:11 am
Re: Can this be done in the Filter of a DataBand
Hello,
You can use a ternary operator instead of IIF, and you can add several filters to the databand.
Thank you.
You can use a ternary operator instead of IIF, and you can add several filters to the databand.
Thank you.
Re: Can this be done in the Filter of a DataBand
OK thanks will try that.
-
- Posts: 800
- Joined: Tue Sep 07, 2021 10:11 am
Re: Can this be done in the Filter of a DataBand
Hello,
Ok.
Let us know about the results.
Thank you.
Ok.
Let us know about the results.
Thank you.
Re: Can this be done in the Filter of a DataBand
Sorry it took a while to get back.
Actually, it did not work because of the use of String in the variables used to compare. So, I am looking at other ways to do what I want.
Actually, it did not work because of the use of String in the variables used to compare. So, I am looking at other ways to do what I want.
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: Can this be done in the Filter of a DataBand
Hello,
We apologize for the delay, but we need some extra time to investigate the issue thoroughly. We will keep you informed about the result as soon as possible.
Thank you for your patience.
We apologize for the delay, but we need some extra time to investigate the issue thoroughly. We will keep you informed about the result as soon as possible.
Thank you for your patience.
Re: Can this be done in the Filter of a DataBand
OK so there is hope after all.
Nice
Nice
-
- Posts: 800
- Joined: Tue Sep 07, 2021 10:11 am
Re: Can this be done in the Filter of a DataBand
Hello,
Could you please send us a sample report with test data that reproduces the issue?
Thank you.
Could you please send us a sample report with test data that reproduces the issue?
Thank you.