Page 1 of 1
Can this be done in the Filter of a DataBand
Posted: Thu Jan 11, 2024 3:06 am
by CCS
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
)
Re: Can this be done in the Filter of a DataBand
Posted: Thu Jan 11, 2024 8:06 am
by Max Shamanov
Hello,
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
Posted: Fri Jan 12, 2024 3:02 am
by CCS
OK thanks will try that.
Re: Can this be done in the Filter of a DataBand
Posted: Fri Jan 12, 2024 6:41 am
by Max Shamanov
Hello,
Ok.
Let us know about the results.
Thank you.
Re: Can this be done in the Filter of a DataBand
Posted: Tue Feb 20, 2024 1:32 am
by CCS
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.
Re: Can this be done in the Filter of a DataBand
Posted: Wed Feb 21, 2024 11:22 pm
by Lech Kulikowski
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.
Re: Can this be done in the Filter of a DataBand
Posted: Thu Feb 22, 2024 5:54 am
by CCS
OK so there is hope after all.
Nice
Re: Can this be done in the Filter of a DataBand
Posted: Thu Feb 22, 2024 1:43 pm
by Max Shamanov
Hello,
Could you please send us a sample report with test data that reproduces the issue?
Thank you.