View the repository and right-click on one of your published reports. Go to Edit. Under the Controls and Resources tab, add an input control. The screen that comes up will ask you to provide a name and resource ID for your new input control: make sure that the resource ID matches the parameter in your report exactly. On this same page you will select an input control type of either single-select query or multi-select query, depending on your needs. The next page will ask you to name and define the query: enter a query that gets values that interest you and use the usual parameter syntax to refer to the "parent" input control, i.e. $P{my_param}, where my_param is the input control that is cascading to the control you are currently creating. On the next page it will ask you to define the parameter value column and the visible columns. Name the parameter value column the exact name of the column that your report is expecting and name the visible column whatever column you prefer displayed in the input controls drop-down menu. So, for example, your query could be like: SELECT STATE_ABBREVIATION, STATE_LONG_DESCRIPTION FROM STATES[/code] and your parameter value name could be STATE_ABBREVIATION and the visible column could be STATE_LONG_DESCRIPTION.