If I have a parameter in my Crystal report that can accept multiple values, is there a way to build those choices into an array and use in my SQL code? So if the user selects 1,2,3, and 4 from the parameter I would like to pass that as an array to use in my SQL code. An example of my SQL code:
select
*
from
tablename
where
id in ({parameter name}) ** this is where the array would be based on the parameter select in Crystal. This array would be 1,2,3,4 to be used in my SQL.
IP Logged
