October 27, 2011 at 9:18 am
I am trying to develop a report which needs to filter the dataset based on user selection. So if user selects, "Active" it will return 0, and if user selects "All", then it will return 1,2,5.
In Report Parameter Properties, I go on Available Values tab, and hit "Specify Values". Then I added the Label and a value.
When I enter just one integer value, it will accept it and filter the dataset correctly ( I have filter setup on the dataset). But when I try to enter the multiple values, "1, 2, 5" - it gives me an error "<Available Value 2> value is not an ineger number".
How can I pass multiple integer values?
I Have attached the screen shot for the error.
------------
🙂
October 27, 2011 at 9:20 am
I usually do this the other way around
ALL = NULL
Then all the values.
If all is selected I just disregard that filter.
October 27, 2011 at 9:30 am
I can't do All = Null because that's not true.
In all, I only need to filter on values 1,2,5. In DB, values 0 - 6 exist.
I also tried going in expression tried these, but it didnt' work:
= "1,2,5"
="1","2","5"
------------
🙂
October 27, 2011 at 9:35 am
You can't.
A list is a series of entries.
Not 1 entry with all the values.
I'm sure there's a way around that but that wouldn't be by the book.
October 27, 2011 at 12:28 pm
You say db values are 0 - 6. What label values would you assign to each one?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply