How to have more than one query in jrxml file?

[sweet_0_dream]

I have a query in jrxml. The response of the query is looks like this:

<Person><ID>...</ID></Person>[/code]

I want to make another query that the ID should comes from first query response (Basically using first query IDs in the nest query). The response of second query is like this:

<Person><ID>...</ID><Job>...</Job><Job>...</Job><Job>...</Job></Person>[/code]

I added a variable which contains the second query and passed the ID to it. But how can I send the Jobs of the second response to my subreport? Any help is appreciated.

[nthapa]

Sounds to me like what you are looking for is cascaded input controls. Couple of helpful links for this one and how to use it.

• https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/cascading-input-controls
• http://passionfordata.blogspot.com/2013/05/cascading-input-control.html

LLet us know if it doesnt work for you.