In one of my reports, an IN parameter is of multiple value type and has been provided with a default list of values for the user to pick from.
These values are being populated from a database table(list of operator names from operator table to be precise). I need this list to be dynamic. Which means, if a new operator record is added to the operator table, the list of default values have to be refreshed and the new operator name must appear in that.
I am using CR 7.0 and requirements is to not use any front end (like vb) to invoke the report.
Is there any way of achieving this. Currently the only way is to refresh the picklist manually from "Edit Parameter Field" dialog box. I am afraid i can't expect the customer to do this after implementation whenever the operator table changes.
These values are being populated from a database table(list of operator names from operator table to be precise). I need this list to be dynamic. Which means, if a new operator record is added to the operator table, the list of default values have to be refreshed and the new operator name must appear in that.
I am using CR 7.0 and requirements is to not use any front end (like vb) to invoke the report.
Is there any way of achieving this. Currently the only way is to refresh the picklist manually from "Edit Parameter Field" dialog box. I am afraid i can't expect the customer to do this after implementation whenever the operator table changes.