I need to create a parameter so a user can select an agency or a range of agencies based on whether they select a particular channel (another drop down). The agency field being referenced is a formula not the actual database field. I can't reference a formula when setting up a parameter so it seems. Also, this will also be part of the drop down selection when the report is put on the web. I didn't know if this would be possible or if you have any other ideas. Any help would be greatly appreciated!!