Using dropdown list for parameter

[cdfly]

Hello,
I have a report that needs to use the month in a filter. I have a dropdown list that has the month name as the label and the integer equivalent as the value.
I tried creating a filter Month([my db date filed]) = Parameter:Month_Name but it gives an error “The arguments to the following function are not valid: = (Equal to).
Is this because it’s not looking at the selected value?


Thanks

 

[drtree]

How do you have your filter set up? If you could post a screenshot, that might be more helpful.

Also, in my experience, sometimes I have to convert the parameter value to an Integer (using Cint) to get the filter to work. You could also try setting up parameters in the report's query source.