RDD BAQ PARAMETER - Parse XML code

Epicor ERP 10
8

And this is how to use that field in the dataset filter and how to make it return all results if it’s empty.

I suppose you could do all this in a calculated filter expression in a BAQ if you just added this as a parameter. Idk. Just playing around.

image
image830×407 13.4 KB

Here’s the top expression for Expression:

=IIF(Code.GetCriteriaPromptValue(Fields!UserCriteria.Value,“ConcatenatedEmpIDs”) = "","1",Fields!EmpBasic_EmpID.Value)

Here’s the bottom one for the value:

=IIF(Code.GetCriteriaPromptValue(Fields!UserCriteria.Value,“ConcatenatedEmpIDs”) = "","1",Split(Code.GetCriteriaPromptValue(Fields!UserCriteria.Value,“ConcatenatedEmpIDs”),","))