2006 IR Open Dicussion Posted August 27, 2006 Share Posted August 27, 2006 By: Neil Lamka - neil_lamka How to pass a list of strings in a parameter 2006-05-11 14:04 I'm trying to put together a report where the user can input a list of groups that they want to exclude from the report. In my report query I want to replace something like ... AND (not (lower(groupid) in ('groupa','groupc'))) ... with AND (not (lower(groupid) in $P{excluded_groups}))) and then have a report paramter with (as an example) the initial expression set to the groups to exclude I tried the following " 'groupa','groupb' " without any success so is there a right way to make this work? Thanks Neil Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now