NCHASHIM Posted July 20, 2021 Share Posted July 20, 2021 My report has a number of parameters, the last of which is PLANNER_AUIC_LIST to be used in this portion of the query's where clause $X{IN, lurn2.auic, PLANNER_AUIC_LIST} I am trying to populate the PLANNER_AUIC_LIST collection by this queryselect UNIT_IDENTIFICATION_CODEFROM (SELECT * FROM (SELECT DISTINCT uic AS UNIT_IDENTIFICATION_CODE from owsADHOC.adhoc_planner_rpt_uic_list where JASPER_ACCOUNT = $P{LoggedInUsername} ORDER BY UIC) )I verified that $P{LoggedInUsername} is returning the expected value by temporaily sticking the value in the header. The parameter PLANNER_AUIC_LIST is only displaying the final record returned by the query. (I tried replacing all of the values and noticed that it only display one value--the last--no matter what is in the table.)What am I missing? Can LoggedInUsername not be used a a query parameter? Link to comment Share on other sites More sharing options...
Solution NCHASHIM Posted July 22, 2021 Author Solution Share Posted July 22, 2021 I found my problem. The input control specified $P{LoggedInUsername} as the VALUE column. I changed it to UNIT_IDENTIFICATION_CODE and the parameter display now displays the values from the table. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now