The report uses two parameters 1. Order placed date and 2. Sales Agent name. First parameter (Order placed date) is a static date range that allows users to enter a date range to run the report. The second parameter is a dynamic parameter that displays Sales Agent names as a picklist. Users can select one or more agent names. This pick list is generated using a SQL command.
We would like to display the names of Sales agents (in the parameter pick list) who were active (i.e. who took orders) between the date range selected in the first parameter.
Currently the picklist, lists names of ALL sales agents (about 100) irrespective of the date selected in first parameter. So, users are forced to go through the entire list of agents instead of agents that were active during that period.
We are using CR 2008 on Edge 3.1.
Any elegant way to achieve this? Your help is appreciated.
Edited by: Mohit Saran on Oct 19, 2009 2:46 PM