Create report in which user wants to pass multiple characters(values) from prompts directly to column filter.
So I have used below syntax with filter functions. And the reports returned results as expected.
(“- Table Name”.”Column name “ IN ( @{Variable}[‘@’]{‘Default Value’} )
Example: Per_Name_Month in ( @{p_month}['@']{'2015 / 07'} )
If you selected Per Name Month are 2015 / 08 and 2015 / 09, then result:
Per_Name_Month in ( '2015 / 08','2015 / 09' )
No comments:
Post a Comment