Populate Parameter with Query

[pbarmak]

I'm new to iReport and I've just created a new Parameter. I don't see any option to populate that parameter with a database query. I only see fields for the parameter name, class type, "is for prompting", default value expression, and description.

 

How can I add a query into this using iReport? I want a simple dropdown that's populated from my database.

 

Thanks.

[mortoza]

Hello

You can use parameter in SQL as $P{paramName}

 

For more details, please have a look at sample .jrxml files in the website.

Rgds,

[villy80]

Hi!

 

The correct sintax to put SQL in a parameter is $P!{paramName}

 

bye

 

Will

[pbarmak]

Not sure the question was clear enough. My goal is not to put a parameter inside a SQL statement. The goal is to POPULATE the parameter with data from a SQL statement. I would want a QueryString within the definition of the parameter so it creates a dropdown with the data from that QueryString.

 

Does that make sense?