I made a parameter for Locations. All and good, until I found out the parameter is not pulling all the locations from the database for some reason.
I click Append all database values to the parameter and it doesn't show several locations. When I delete the parameter and run the report wide open, the locations pull in it.
What am I missing here?