Hi, I hope I am posting this in the correct place. I'm a relative newbie to Jasper Reports having worked with both Crystal and SSRS in the past, and I am having some issue getting my head around a report. I am using iReport Designer 4.5.1 to design the report. I need to produce a report that selects a set of values from a database table based on a company. I would like the user to be able to select the name of the company from a list of available companies rather than having to remember and type in the company's unique database ID number. I can't work out how to confgure the report to load a list of the customers from the database and use this list in the parameter prompt. So, in short, how do I create a parameter prompt that contains a drop-down list of values that are loaded from the database and then use the value selected from that drop-down list to run the SQL query in the report itself? Thanks for any help or advice you can offer! Chris.