parameters in ad-hoc domain

how can I use built-in parameter LoggedInUserName in ad-hoc domain reports?

sureshjsper's picture
Joined: Aug 3 2011 - 4:39am
Last seen: 7 years 6 months ago

Why is adhoc domain report question classified as "Jaspersoft ETL" question?

hozawa - 7 years 9 months ago

1 Answer:

Unfortunaley the Built In User Paramerters are not accessible yet via AdHoc or Domains.

There Parameters can be Accessed
- Via Jaspersoft Stiudio Reports Slook at: http://community.jaspersoft.com/wiki/built-parameters-logged-user
- Via Input Control Queries or Domain Queries (scroll to the bottom of: http://community.jaspersoft.com/documentation/tibco-jasperreports-server-
administration-guide/v610/query-based-input-controls )
- To do some type of User Level Security you can access them from the Domain Security File see: http://community.jaspersoft.com/documentation/tibco-jasperreports-server...

The only thing you can access form Adhoc are the User, Server and Tenant Profile Arributes via the Attributes('Name','Scope') function of Calculated fields and DomEL. So as a workaround you can create a Profile Attribute of the users that stores the username, this may be tricky if you are not doing SSO, but you may do a batch processs to create them using the REST API (http://community.jaspersoft.com/documentation/tibco-jasperreports-server...)

Here is how you use Profile Attributes in an AdHOC Calulated Field, You can also use them inside DOMAINS as Calculated fields, domain filters or in the definition of Derived Tables

marianol's picture
16388
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 8 months ago
Feedback
randomness