I have an unexpected problem with my report filter value. Two parameter filter lists: Year and Person Name. Person names are selected based on the selected year .
Let's say a person record:
PersonID PersonName Year
12345 Mike Smith 2012
The problem is that Mike does not show in the Person Name parameter list if:
After clicking Preview, click Select All in the Year parameter filter list. Mike does not show in the Person Name filter list.
If I select 2012 in the Year filter after Preview is clicked, Mike shows in the Person Name filter list, and then I select "Select All" in the Year filter list, Mike also shows in the filter list.
The query statement is working fine.
Why/How can this happen? I appreciate any help.