Create a new dataset with the following query and use the parameter.
SELECT DISTINCT ParamValue from (
SELECT 'ABC' AS Attri1,'Yes' AS ParamValue
UNION ALL
SELECT 'PQR' AS Attri1,'Yes' AS ParamValue
UNION ALL
SELECT 'XYZ' AS Attri1,'Yes' AS ParamValue
UNION ALL
SELECT 'ABC' AS Attri1,'No' AS ParamValue
UNION ALL
SELECT 'PQR' AS Attri1,'No' AS ParamValue
) X
Regards, RSingh
No comments:
Post a Comment