Thanks for your reply.
Here is the solution after doing many Trials.
***Remember this works only for data type "STRINGS". I'm working on Number data type values.
Set the values Inside a Parameter field.
Value field :- select the Database column (Don't press insert)
Default Value :- All
Custom Values :- True
Multiple Values:- False
In Record Selection Formula
(If Instr({?My_Parameter},'*') > 0 then
{Table.ColumnName} Like Uppercase({?My_Parameter})
else if (uppercase({?My_Parameter}) = "ALL" ) then
TRUE
else
{Table.ColumnName} IN Split({?My_Parameter},',')
)
This works for all possibilities of Parameter values with Single value, Multiple values separated by comma, wild card match(SCOTT*), All records.
Now you can view the parameter values as a part of SQL Query.
I would like to share this with all of you.
VK
IP Logged
