Can this be done in the Filter of a DataBand

[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
)

[Max Shamanov]

Hello,

You can use a ternary operator instead of IIF, and you can add several filters to the databand.

Thank you.

[CCS]

OK thanks will try that.

[Max Shamanov]

Hello,

Ok.
Let us know about the results.

Thank you.

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

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

[CCS]

OK so there is hope after all.

Nice

[Max Shamanov]

Hello,

Could you please send us a sample report with test data that reproduces the issue?

Thank you.