Question
4
Replies
1956
Views
Posted: September 27, 2016
Last activity: September 30, 2016
Closed
Solved
Report definition - list where parameter value contains the column value
For a report defnition, if we have a parameter pA and column source Col1, we can check if column value contains the parameter value as the substring by using filter condition
.Col1 contains param.pA
Now, we have a requirement to check if the parameter contains the column value, how to write the filter condition for this?
Thanks
Accepted Solution
Posted: 4 years ago
If you want to do that, you can use the pxFind function on the LHS to get the index of col1 in param.pA and check if it returns a positive integer or not.
I am not sure I understand. What you are trying to check with
.Col1 contains param.pA
is if value in Col1, in the database, contains the value in parameter pA. So we are checking the column's value with the parameter value.
Are you trying to check if the parameter contains a different column name?