How to insert a value into a report from a different sql query?

[matthew.friendars.usda.go]

Hi Folks:

I have a report for new orders.  There are several folks that order items.  I need  allow the person to select their email address from a list and have it inserted into the report in the email section (see pic please).

I already have a parameter on the report to limit it to just one order number.  The email address is not part of the query that fills out the report.

So my question is:

Should I do a subreport or variable that would allow the user to select the email address (which is then inserted into the report)?  Any ideas would be appreciated,

Thank you,

Matthew

[yama818]

This may not be the best way to do it, but I was able to achieve this by using the table component.
Tie a new dataset to the table component and write SQL to return only one item in this dataset.
ex) select email from email_table where id = $P{xxxx}

preview image

Design image

 

I hope this is helpful.

 

 

[matthew.friendars.usda.go]

Thank you Yama818  for the idea.  I think that will work though I still have not got it working yet.  I can get the table to return an email that I set in the SQL.  If I set a parameter though nothing is returned.  (Set the parameter in the table like below:

I set the same parameter (Just called "EMAIL") in the main report so it will as for it but doesn't pass it to the table.  I'm probably doing something stupid.  Once I upload it to the server I want to have a pick list so they can choose the email.  Thank you for any advice or help :)

[matthew.friendars.usda.go]

I got it... thanks your idea worked great!!