Accessing Dataset Properties
how can i access a dataset's properties from report designer (rs2k)? i'm using the results of the user's selection from one parameter's dropdown list to populate another parameter's dropdown list; that is working perfectly. the second one's results are not used as a user-selection list, per se, it is to be passed to the report's main query as a comma-delimited "IN" list in the sql statement.
i'm not sure how to turn the second dataset's resultset of 3-5 values into a comma-delimited string for the main query. any ideas?
i also would like to not have the user see the second dropdown, since it is not for the user's benefit, per se; i really only need its values for the main query.
thanks in advance
|