I created a tabular report which allows you to select the user for which you want to run this report.
- c.APPLICATION_NAME as APPLICATION, c.ENTITLEMENT_TYPE, c.ENTITLEMENT_NAME as ENTITLEMENT, a.LAST_NAME, a.FIRST_NAME
from avuser.PV_USERS a,
and c.ENTITLEMENT_TYPE != 'account'
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?