AnsweredAssumed Answered

How to input UserID at the report run time

Question asked by Karine Slkuni Employee on May 26, 2016
Latest reply on May 27, 2016 by Karine Slkuni

I created a tabular report which allows you to select the user for which you want to run this report.

 

(select distinct

  1. c.APPLICATION_NAME as APPLICATION, c.ENTITLEMENT_TYPE, c.ENTITLEMENT_NAME as ENTITLEMENT, a.LAST_NAME, a.FIRST_NAME

from avuser.PV_USERS a,

     avuser.V_AVR_USERACCESS c

where c.USER_ID=a.USER_ID

and c.ENTITLEMENT_TYPE != 'account'

and a.USER_ID=:tmpUserID

order by c.ENTITLEMENT_TYPE)

 

Default value of variable :tmpUserID ( e.g. tmpUserID=’jataya’) can be defined when I edit the report and save it.

Now I can run the report and get data for user 'jataya'.

Question: Is it possible to input another UserID (e.g. tmpUserID=’dpeterson’) at report run time (and not while editing the report).

Would it be possible to create a form to run this report and enter the User_ID in the form? I assume it's possible using jsp. Can anyone help me to create such a form?

Thanks!

Outcomes