October 8, 2009 at 2:08 am
hello i'm a beginner at this but i think my question is related to this thread
Problem:
i'm trying to filter in my "group by" using multiple selections of a parameter called "Year"
1) i added my report parameter and selected "Allow multiple values"
[see attached screenshot]
2) then in my series group properties i added a filter where the value was the report parameter above
[see attached screenshot]
Attempts:
a) i have tried
=split(Join(Parameters!Year.Value,","),",")
and
=split(Join(Parameters!Year.Label,","),",")
and selecting IN instead of "=" in the operator field but i just get the error message "Value is not an integer number"
b) if i use =Parameters!Year.Value(0)
then the query runs but i obviously only get the first year from the (many) selection
please help
October 11, 2009 at 7:17 am
hello everyone.... i'm still stuck on this.... any ideas?
sorry to bother you
October 21, 2010 at 8:09 am
I am trying to use the "IN" clause filter on the Data Set as described in this post. As soon as I select "IN" the use of the function goes away. It is grayed out. I'm not sure why it is doing that but it is preventing me from using it. I am using the function to allow the filter to toggle between being used in the selection and not being used.
Any advice?
Thank you,
Nathan
October 21, 2010 at 9:04 am
What is the data type of "YEAR" from your demandVersusTemp dataset?
Try this:
Select your Year field from your dataset.
"IN"
[@year]
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply