twmoore

In order to enforce row-level security, we are going to add a Profile Attribute that will be used in the SELECT for the iReport. How would one get the value of a Profile Attribute in iReport? I saw a post about creating a Java class to change the SQL directly, but there must be an easier way to do it. Thank you.

I am looking for something that lists the repository tables, their description, their columns and the column descriptions. Does such a thing exist? Is it available to the public?

Virginia Tech is also seeing this issue. We are seeing some major bugs in the Ad Hoc editor that are causing Ad Hocs to no longer run correctly. A list of bugs that will be included in the next release, that was supposed to be out by now, would be extremely helpful.

I have a ticket in with Support about this, but wanted to see if anyone had encountered this issue. I have created an iReport that contains a subreport. This subreport contains a Maps Pro object that shows counts by state. I selected PDF Preview in order to view the results. It is working. I tried to print the PDF and the map does not print. I deployed the report to the server and while the map does appear via HTML and when exported to PDF, it still does not print. Jasper Support gave me some suggestions for printing within Adobe Reader. None really work. I am getting mixed results. One time everything prints correctly, with the exception of the first page map being small. Another time, the first page map is small, some of the other pages print correctly and others have blank pages. I have tried different printers, but get the same results. Any suggestions?

I am curious if anyone has an official standard for creating iReport. Things like fonts, spacing, header/footer format, Field/Variable/Parameters nameing convention, etc. If so, would you be willing to share it? We are using Jasperserver and iReport for our Course Evaluation Data Mart. We will be expanding to other Data Marts that are maintained by other groups. It would be nice to have a common standard. Thank you.

I think brooneyx1 might have left the defaultValueExpression for LoggedInUserName. I have done something similar with iReports. I have attached what I use. I tried to find the webpage that documents com.jaspersoft.jasperserver.api.metadata.user.domain.User but can't find it. There are a number of other methods you can call for the class. Code: <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User"/> <parameter name="LoggedInUsername" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[(Object)$P{LoggedInUser}.getUsername()]]></defaultValueExpression> </parameter>

You could also do a DECODE in the SQL Statement itself. Something like: SELECT PO."NUM", CUSTOMFIELDVIEW."INFOFORMATTED", CUSTOMFIELDVIEW."CFTABLEID", CUSTOMFIELDVIEW."CFNAME", PO."ID" AS PO_ID, PO."VENDORCONTACT" AS PO_VENDORCONTACT, CUSTOMFIELDVIEW."CFSORTORDER" AS CUSTOMFIELDVIEW_CFSORTORDER, CUSTOMFIELDVIEW."CFID" AS CUSTOMFIELDVIEW_CFID, CUSTOMFIELDVIEW."CFDESCRIPTION" AS CUSTOMFIELDVIEW_CFDESCRIPTION, CUSTOMFIELDVIEW."CFTYPEID" AS CUSTOMFIELDVIEW_CFTYPEID, CUSTOMFIELDVIEW."CFREQUIRED" AS CUSTOMFIELDVIEW_CFREQUIRED, CUSTOMFIELDVIEW."INFO" AS CUSTOMFIELDVIEW_INFO, CUSTOMFIELDVIEW."RECORDID" AS CUSTOMFIELDVIEW_RECORDID DECODE(Customfieldview.cfsortorder,'2','APPROVED','') FROM "CUSTOMFIELDVIEW" CUSTOMFIELDVIEW INNER JOIN "PO" PO ON CUSTOMFIELDVIEW."RECORDID" = PO."ID" WHERE (((CUSTOMFIELDVIEW.CFTABLEID) = 397076832)) and Customfieldview.cfsortorder = 2 and po.num = '10010'

Have you implemented Roles? You can hide content based upon Role and/or User. If you want the Directors to see only a single dashboard, you could put them in a Role, grant that Role permission to see ther dashboard and to not see everything else. We have grouped our reports in folders by subject area. We have a different Role for each area and that Role only sees the appropriate folder.

You don't really need to have a separate parameter. You can write your SELECT as: Code:Select * from companies where companies.copm_name LIKE $P{COMPANY_NAME} AND companies.comp_status LIKE $P{COMPANY_STATUS}

We enforce data security based upon Oracle User ID. Our Jaspersoft Server IDs match a User's Oracle ID. So I am trying to use our existing Security View to filter records. We have setup a Profile Attribute called JSUSER which I am using to filter records. I have attached my XML security file. I think it is correct based upon the manuals. Any help would be appreciated. Thank you. Tim Code:<securityDefinition xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema" version="1.0" itemGroupDefaultAccess="granted"> <resourceAccessGrants> <!-- Row level security --> <resourceAccessGrantList id="JoinTree_1" label="ListLabel" resourceId="DMMGR_FUND_ORGN_SECURITY"> <resourceAccessGrants> <resourceAccessGrant id="Fund_Orgn_Security_Grant"> <principalExpression> <![CDATA[authentication.getPrincipal().getAttributes().any{ it.getAttrName() in ['JSUSER'] }]]> </principalExpression> <filterExpression> DMMGR_FUND_ORGN_SECURITY.USER_ID_ENTERED in (groovy('authentication.getPrincipal().getAttributes().find{ it.attrName == "JSUSER" }.attrValue')) </filterExpression> </resourceAccessGrant> </resourceAccessGrants> </resourceAccessGrantList> </resourceAccessGrants></securityDefinition>