Jump to content
We've recently updated our Privacy Statement, available here ×


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

dszeto's Achievements


Collaborator (7/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges




Community Answers

  1. Issue DescriptionWhen starting TIBCO JasperReports® Server, the login page does not appear and instead the error message is "this page cannot be displayed". ResolutionTo troubleshoot this, it helps to narrow this down by checking whether the application server itself is running. If, for example, you are using Tomcat and http://yourServer:port loads the Tomcat landing page, then this demonstrates the application server is running. The application server logs will also provide clues as to whether Jasper loaded correctly. For instance, in catalina.out you would see INFO: Deploying web application directory /path/to/jasperserver-pro In this case, this message was not appearing in the logs and upon further review, they had some security enabled that performs automatic redirection of requests and so if the url was https instead of http Jasper would not load.
  2. Issue Description:If my report contains a parameter of type java.util.Collection, how do I print the values in the collection in the report? Resolution:You would first need to convert the collection parameter into a java.util.ArrayList parameter by creating a second parameter of the ArrayList type. You then create a new ArrayList object out of the collection parameter. From this second parameter, you use the subList method to extract elements of the ArrayList to display in for instance, text fields. Attached is an example report that illustrates this. collection.jrxml
  3. Is JasperReportsServer on a different machine? If so, are you able to connect to Mongo using a Mongo client from that machine? That will tell us if the machine or JRS is having issues connecting to Mongo.
  4. Did you import any old data into your new AWS Jasper instance? An old theme imported from an older JasperReportsServer deployment will cause these misalignment issues and if that's the case, re-import the default theme for that version.
  5. How about in your dividend check whether that subtraction is > 0 and if not, set the dividend to 0. Once that is done then you can do an <expression> ? 0 : <result>. I am not sure how you would check if the result of the division is NULL unless you are checking whether the variables themselves are NULL.
  6. If you are using the same JDBC driver in JasperStudio as in your SQL Management Studio, does the query still fail?
  7. You can also restart the app server hosting JasperReportsServer.
  8. Does the subreport run on its own? If yes, where in the main report did you put your subreport? Summary band?
  9. I made a slightly different statement that works for me: $V{Variable_1}.equals("test") ? $F{amount} : ""
  10. Issue Description:How can I configure TIBCO JasperReports® Server to look for users in a multi-organization LDAP? Resolution:You make multiple ldapAuthenticationProvider beans and name them differently. Make multiple userSearch beans, one for each search. Reference the userSearch bean in its corresponding ldapAuthenticationProvider bean's constructor. For the JSDefaultLdapAuthoritiesPopulator constructor under your ldapAuthenticationProvider bean, put in the correct search string for the groups you want to reference (usually this is the same across all ldapAuthenticationProvider beans, but it might not be for your case). In your ldapAuthenticationManager bean, make sure you put all the ldapAuthenticationProvider bean names in the ref local section. The attached sample xml file helps illustrate these instructions. Please customize this to your own local environment. applicationcontext-externalauth-ldap-mt-multiorg.xml
  11. Issue Description: When previewing a report in jasperStudio, the following error occurs: [toc]Error incrementing bidimensional dataset. Error Trace net.sf.jasperreports.engine.JRRuntimeException: Error incrementing bidimensional dataset. at net.sf.jasperreports.engine.analytics.dataset.MultiAxisDataService.addRecord(MultiAxisDataService.java:373) at net.sf.jasperreports.engine.analytics.dataset.FillMultiAxisDataset.customIncrement(FillMultiAxisDataset.java:110) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:201) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:191) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:737) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:260) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:103) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:607) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:961) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1840) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1159) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1088) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:983) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:328) at net.sf.jasperreports.engine.analytics.dataset.MultiAxisDataService.addRecord(MultiAxisDataService.java:369) ... 18 more [/code]Resolution:In the report design a chart that uses a separate subdataset was placed in one of the detail bands. Typically, charts should be placed in a band that only renders one e.g. the summary band for a few reasons: multiple calls will be made for each row rendered to the database slowing down performance output may look confusing to the end user JR will not be able to properly iterate through the returned data, as was the case in this report that caused the error stack trace Moving the chart in this report to the summary band allowed for the report to preview.
  12. dszeto

    Updating CAS beans

    Issue Description:Supposing modifications are made to application-Context xml to dynamically populate certain beans (externalAuthProperties) with a CAS integrated TIBCO JasperReports® Server. Is there a way to read and update the beans without restarting the application server hosting JasperReports® Server? Resolution:Reload the JasperReports Server web application.
  13. Issue Description: When trying to connect to TIBCO JasperReports® Server via TIBCO Jaspersoft® Studio a NullPointerException is generated instead. Resolution:After reinstalling Jaspersoft® Studio and still encountering the exception, check the JVM for any additional arguments and the following is found: java -versionPicked up JAVA_TOOL_OPTIONS: -Djavax.net.ssl.trustStoreType=Windows-ROOTjava version "1.8.0_152" Java SE Runtime Environment (build 1.8.0_152-b16)Java HotSpot 64-Bit Server VM (build 25.152-b16, mixed mode)[/code]The environment variable -Djavax.net.ssl.trustStoreType was removed from the JVM startup and the NullPointerException disappeared, allowing for connection to the JasperReports® Server repository. This variable must point to a certificate/jks file.
  14. Issue Description: When attempting to create a new user via REST API the error code returned is an http 400 error. Resolution:The user being created has several roles associated with it, including ROLE_SUPERUSER. Attempts to replicate in house showed one key difference in our test cases, that being in the in house test case the superuser user was used to login and then submit the request while in the customer's test case, a tenant administrator was used. Tenant administrator users typically do not have the ability to assign that role to users, as this role exists at the root level. Once they used the superuser account, creating the user, succeeded.
  15. Issue Description: I want only a certain group within my Active Directory to be able to login to JasperReportsServer. How do I achieve that? Resolution: What you can do is make sure users get no roles by default when trying to login, and map your LDAP group you want to allow logging in to an internal JasperReportsServer role that allows for login. This is all done within the applicationContext-externalAuth-LDAP-mt.xml file. So for instance you might have something like <bean> <property name="defaultInternalRoles"> <list> </list> </property> <property name="organizationRoleMap"> <--> <!--Example of mapping customer roles to JRS roles <entry> <key> <value>Admin LDAP!</value> </key> <!-- JRS role that the <key> external role is mapped to <value>ROLE_ADMINISTRATOR</value> </entry> </map> </property> </bean>
  • Create New...