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

Anuja Vilas Bhujbal

Jaspersoft Staff
 View Profile  See their activity

  • Posts

    36

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by Anuja Vilas Bhujbal

  1. Anuja Vilas Bhujbal
    Hello, You can publish the report along with the data adapter so that the report can access the JSON data. Please refer to the below articles for more details- https://community.jaspersoft.com/wiki/using-data-adapters-fill-reports-json-data-remote-url https://community.jaspersoft.com/wiki/publishing-data-adapter-tibco-jaspersoft-studio-tibco-jasperreports-server
  2. Anuja Vilas Bhujbal
    Hello, It seems like Jersey-server dependency is required and you would need to add it to your pom.xml and try deploying. <dependency> <groupId>org.glassfish.jersey.core</groupId> <artifactId>jersey-server</artifactId> <version>2.11</version> </dependency> Please refer to the below link for more details - https://stackoverflow.com/questions/26906534/java-lang-classcastexception-org-glassfish-jersey-servlet-servletcontainer-cann
  3. Anuja Vilas Bhujbal
    Hello, The java.lang.NoSuchMethodError error means that the studio is not able to find the jar in the classpath of the project. The error has two possibilities - Either method definition doesn't existIf method definitions exist, then they might have incompatible changes i.e. you might be using a different version of jar/class during runtime.Hence, please check if the jar exists in the classpath of the project or if there is any compatibility change.
  4. Anuja Vilas Bhujbal
    Hello, Can you please elaborate on your requirement? Please let me know what you mean by a context variable and also provide an example to help be better understand your requirement.
  5. Anuja Vilas Bhujbal
    Hello, You can use the jsonql query instead of JSON to use multiple lists in the report. For example, in the "Dataset and query" wizard, select the jsonql query language and set it as below - Please refer to the below link for more details on jsonql. https://jasperreports.sourceforge.net/sample.reference/jsonqldatasource/index.html#jsonqldatasource
  6. Anuja Vilas Bhujbal
    Hello, It seems like there might be two different versions of the Bouncy Castle library on your Java classpath. Please refer to the below links for more details - https://stackoverflow.com/questions/27948100/jmeter-throwing-error-class-org-bouncycastle-asn1-asn1primitive-overrides-final https://stackoverflow.com/questions/17212410/itext-bouncycastle-throws-java-lang-verifyerror-class-overrides-final-method
  7. Anuja Vilas Bhujbal
    Hello, It seems like we have a known issue where a similar issue is seen while exporting OLAP to PDF which is caused as the OLAP is using fop-0.95-1.jar to print PDFs and that jar depends on batik-gvt:jar. Our Engineering team is still working on the defect.
  8. Anuja Vilas Bhujbal
    Hello, Thank you for attaching the file. Can you please let me know what version of Java/jdk you have on the server on which you are installing the Jasperserver? If you do not have any JDK installed, please try installing Java 11 and let us know if the JAsperserver gets installed properly.
  9. Anuja Vilas Bhujbal
    Hello, Can you please share the entire server logs i.e /WEB-INF/logs/jasperserver.log and tomcat/logs/catalina.out file to help us understand the issue?
  10. Anuja Vilas Bhujbal
    Hello, Can you please share the installation logs to help us better understand the issue? You will find the logs under the installation directory of the binary installation.
  11. Anuja Vilas Bhujbal
    Hello Menghong, It seems like you missed the entry for "read+write" thus this was giving some wrong output for this condition. Please refer to the below modified query. SELECT jiobjectpermission.uri, jirole.rolename, CASE WHEN jiobjectpermission.permissionMask = 1 THEN 'admin' WHEN jiobjectpermission.permissionMask = 2 THEN 'read only' WHEN jiobjectpermission.permissionMask = 6 THEN 'read + write' WHEN jiobjectpermission.permissionMask = 18 THEN 'read + delete' WHEN jiobjectpermission.permissionMask = 30 THEN 'read + write + delete' WHEN jiobjectpermission.permissionMask = 32 THEN 'execute only' Else 'no access' END AS Permission FROM jiobjectpermission LEFT JOIN jirole ON jirole.id = jiobjectpermission.recipientobjectid WHERE jiobjectpermission.recipientobjectclass LIKE '%RepoRole' and jiobjectpermission.permissionMask <> 0 UNION SELECT jiobjectpermission.uri, '' AS rolename, CASE WHEN jiobjectpermission.permissionMask = 1 THEN 'admin' WHEN jiobjectpermission.permissionMask = 2 THEN 'read only' WHEN jiobjectpermission.permissionMask = 6 THEN 'read + write' WHEN jiobjectpermission.permissionMask = 18 THEN 'read + delete' WHEN jiobjectpermission.permissionMask = 30 THEN 'read + write + delete' WHEN jiobjectpermission.permissionMask = 32 THEN 'execute only' Else 'no access' END AS Permission FROM jiobjectpermission LEFT JOIN jiuser ON jiuser.id = jiobjectpermission.recipientobjectid WHERE jiobjectpermission.recipientobjectclass LIKE '%RepoUser' and jiobjectpermission.permissionMask <> 0 ORDER BY 1 asc Also, JIObjectPermission is a mapping table of permission masks for certain URI to certain recipients. In JRS the recipient can be either a user or a role, this information is stored in the recipientObjectClass column. Based on the recipientObjectClass column you can join the respective table - either User or Role and get info about what kind of permission is assigned to what object. Bear in mind that permissions in JRS are inheritable and go from top-level object to bottom-level object in the repository structure -> root folder > folder > sub folder > object. So this table will only contain explicitly set permissions, instead of all permissions on the server.
  12. Anuja Vilas Bhujbal
    Hello, Can you please share your report design to help us better understand it?
  13. Anuja Vilas Bhujbal
    Hello Anabelle, Can you please let us know what your current connection URL looks like to connect to Informix? Also, please refer to the below link to check how you are forcing SSL to your DB and see if it is helpful. https://www.ibm.com/docs/en/informix-servers/14.10?topic=options-connecting-jdbc-applications-ssl
  14. Anuja Vilas Bhujbal
    Hello Sangmesh, Please refer to the below link to format the decimals of the tooltip. You will need to add the formatted function in plotOptions.series.tooltip.formatter in the advanced properties of the HTML5 chart. https://community.jaspersoft.com/wiki/html5-charts-custom-formatting-how-split-value-commas-and-decimal-point Also, to use the highcharts functions, you will need to configure your Studio and Jasperserver as given in the below link for the functions to work. https://community.jaspersoft.com/wiki/using-functions-html5-charts-highcharts
  15. Anuja Vilas Bhujbal
    Hello Anibal, You will need to add a wild card property setting to reference the original header suppression into your report sub-element (table group headers). net.sf.jasperreports.export.{format}.exclude.origin.report.{arbitrary_name}=* For example, you will need to set the below properties in the report for the property_address_header - <property name="net.sf.jasperreports.export.csv.exclude.origin.band.property_address_header" value="groupHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.group.property_address_header" value="property_address"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.report.property_address_header" value="*"/>
  16. Anuja Vilas Bhujbal
    Problem: A user had a requirement where they needed the measure column data cell borders in the Adhoc view report crosstab as they are seen for the other rows and columns in the Jasperserver. Solution: For displaying the crosstab measure data cell border, you can make changes in the default ad-hoc report template which is located in the /public/templates folder. Please locate the below code in the template and change the linewidth of the top and bottom pen to 1.0. You can then use this template to create the adhoc report and would be able to see the borders for the measure data cell. <style name="CrosstabDetailTextStyle" style="CrosstabBaseTextStyle" forecolor="#333333" backcolor="#FFFFFF" hTextAlign="Right" hImageAlign="Right" isBold="false"> <box> <topPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> </box>
  17. Anuja Vilas Bhujbal
    Problem: A user had a requirement where they needed the measure column names to be bold in the Adhoc view report crosstab as they are seen for the other rows and columns in the Jasperserver. Solution: You can use the default report template which is used to create a report from the adhoc view and make changes in it to make the measure bold. You must edit the Actual size report template in the JasperSoft Studio under the/public/templates folder in the Jaserserver repository and set the isBold to true as below in the Actual Size template for the column and row measure. <style name="CrosstabColumnMeasureHeaderTextStyle" style="CrosstabMeasureHeaderTextStyle" forecolor="#757575" isBold="true"/> <style name="CrosstabRowMeasureHeaderTextStyle" style="CrosstabMeasureHeaderTextStyle" backcolor="#FFFFFF" forecolor="#757575" isBold="true">
  18. Anuja Vilas Bhujbal
    Problem: There is a use case where a user wants to give access to users to only upload images from the Add Resource ->File menu in the Jasperserver repository but the other options should not be available to the users. Solution: You must make changes in the WEB-INFactionModel-search.xml to achieve this requirement. You need to add a condition tag to check the authenticated role assigned to the user and then give access to the file types. I am attaching my sample actionModel-search.xml where I have added a condition to give access to all file types to the ROLE_ADMINISTRATOR and ROLE_SUPERUSER only and gave access to upload images to ROLE_SP_USER and ROLE_SUPERUSER. The code will look something like below in the XML file - <selectAction labelKey="RM_NEW_RESOURCE_FILE" className="flyout" clientTest="canResourceBeCreated" clientTestArgs="FileResource"> <condition test="checkAuthenticationRoles" testArgs="ROLE_ADMINISTRATOR, ROLE_SUPERUSER"> <condition test="isProVersion"> <option labelKey="resourceTypes.access.grant.schema" action="invokeCreate" actionArgs="FileResource@@accessGrantSchema" className="up"/> </condition> <option labelKey="RM_NEW_RESOURCE_CONTENT_RESOURCE" action="invokeCreate" actionArgs="FileResource@@contentResource" clientTest="canResourceBeCreated" clientTestArgs="ReportUnit" className="up"/> <option labelKey="resourceTypes.font" action="invokeCreate" actionArgs="FileResource@@font" className="up"/> <option labelKey="resourceTypes.css.file" action="invokeCreate" actionArgs="FileResource@@css" className="up"/> <option labelKey="resourceTypes.jar" action="invokeCreate" actionArgs="FileResource@@jar" className="up"/> <option labelKey="resourceTypes.jrxml" action="invokeCreate" actionArgs="FileResource@@jrxml" className="up"/> <option labelKey="resourceTypes.olap.schema" action="invokeCreate" actionArgs="FileResource@@olapMondrianSchema" className="up"/> <option labelKey="resourceTypes.resource.bundle" action="invokeCreate" actionArgs="FileResource@@prop" className="up"/> <option labelKey="resourceTypes.style.template" action="invokeCreate" actionArgs="FileResource@@jrtx" className="up"/> <option labelKey="resourceTypes.xml.file" action="invokeCreate" actionArgs="FileResource@@xml" className="up"/> <option labelKey="resourceTypes.mongodb.jdbc.config" action="invokeCreate" actionArgs="FileResource@@config" className="up"/> <option labelKey="resourceTypes.mongodb.schema" action="invokeCreate" actionArgs="FileResource@@mongoDbSchema" className="up"/> <option labelKey="resourceTypes.azure.certificate.file" action="invokeCreate" actionArgs="FileResource@@cer" className="up"/> <option labelKey="resourceTypes.secure.file" action="invokeCreate" actionArgs="FileResource@@secureFile" className="up"/> <option labelKey="resourceTypes.key" action="invokeCreate" actionArgs="FileResource@@key" className="up"/> <option labelKey="resourceTypes.pub" action="invokeCreate" actionArgs="FileResource@@pub" className="up"/> <option labelKey="resourceTypes.ppk" action="invokeCreate" actionArgs="FileResource@@ppk" className="up"/> </condition> <condition test="checkAuthenticationRoles" testArgs="ROLE_SP_USER, ROLE_SUPERUSER"> <option labelKey="resourceTypes.image" action="invokeCreate" actionArgs="FileResource@@img" className="up"/> </condition> </selectAction> Please locate the below selectAction tag in the file for more details. <selectAction labelKey="RM_NEW_RESOURCE_FILE" className="flyout" After making the changes in the XML file, you will need to restart the application server for the changes to get reflected. actionmodel-search_2.xml
  19. Anuja Vilas Bhujbal
    Hello, It seems like the decimal format seen in the Orcal Apex PDF is referring to the German format. You might need to check the localization settings of the PDF application.
  20. Anuja Vilas Bhujbal
    Hello Paul, Please refer to the below link and check if you have configured the report correctly to use the localization files. https://community.jaspersoft.com/wiki/working-localization-files-jaspersoft-studio
  21. Anuja Vilas Bhujbal
    Hello Rachelle, Please refer to section "5.6 Calculated Fields and Measures" from the below Jasperserver user guide for details regarding calculated fields and measures in the ad-hoc view. https://community.jaspersoft.com/documentation/v8-v80-v800-v801/tibco-jasperreports-server-user-guide
  22. Anuja Vilas Bhujbal
    Hello Richard, As per the Platform Support Guide of the Jasperserver7.5, the tomcat 8.5.82 is not certified to use with the 7.5 JRS. The version of Apache tomcat from 8.5.0 - 8.5.43 and 9.0.1 - 9.0.27 are certified for the 7.5 JRS. https://community.jaspersoft.com/documentation/v75-v750/tibco-jaspersoft-platform-support Also, we do not have any documentation as such to upgrade tomcat for the JAsperserver but you can refer to the below community link and see if it is helpful. https://community.jaspersoft.com/questions/1183231/upgrading-apache-tomcat-independent-jasperreportsserver-application
  23. Anuja Vilas Bhujbal
    Hello Oliver, You can localize the reports do display them according to your user's locale using the locale bundles. Please refer to section "6.7 Localizing Reports" of the below Jasperserver user guide. https://community.jaspersoft.com/documentation/v8-v80-v800-v801/tibco-jasperreports-server-user-guide
  24. Anuja Vilas Bhujbal
    Hello, Try connecting to a single node in the MongoDB mainly the primary node in the cluster instead of connecting to the cluster URL.
  25. Anuja Vilas Bhujbal
    Hello Erika, Please refer to the below documentation - https://community.jaspersoft.com/documentation/v8-v81-v810/tibco-jasperreports-server-community-project-upgrade-guide
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore