sudata

Issue Description:When using Line chart in Adhoc view, Customer what's to remove the line which is connecting between the two data points and only show data points instead. Resolution: To achieve this you will need to add below 3 advanced properties in adhoc designer to remove line between the data points for Line chart. plotOptions.series.lineWidth = 0 plotOptions.line.shadow = false plotOptions.series.states.hover.enabled = false Once you have added this as a Key -Value pair , This will get auto updated on the screen. Hope this helps. Have a GREAT day ahead! Thank you

Issue Description:When using Spline chart in Adhoc view, Customer what's to remove the curve line which is connecting between the two data points and only show data points instead. Resolution: To achieve this you will need to add below 3 advanced properties in adhoc designer to remove line between the data points for Spline chart. plotOptions.series.lineWidth = 0 plotOptions.spline.shadow = false plotOptions.series.states.hover.enabled = false Once you have added this as a Key -Value pair , This will get auto updated on the screen. Hope this helps. Have a GREAT day ahead! Thank you

Issue Description: Sometime customer requires to use dynamic numeric pattern expression for columns based on the server attribute. And they follow below suggestions provided in wiki article: https://community.jaspersoft.com/wiki/how-create-dynamic-numeric-pattern-expression-based-server-attribute , But for this when we use "Zero" as the decimal value then report execution is causing the error. ============================================================================== Resolution: To support adding zero decimal you will need to add one more parameter and use as below. <parameter name="NumberPattern" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["#,##0" + ($P{ServerAttribute_NoOfDecimals}.equals("0") ? "" : String.format(".%0" + $P{ServerAttribute_NoOfDecimals} + "d", 0))]]></defaultValueExpression> </parameter> <parameter name="CurrencyPattern" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["¤" + $P{NumberPattern} + ";¤(" + $P{NumberPattern} + "-)"]]></defaultValueExpression> </parameter> ======== Attaching ZeroDecimalSupport.jrxml for the reference and make changes in your report to add. Here we have 3 parameter in total. a) ServerAttribute_NoOfDecimals b) NumberPattern c) CurrencyPattern. Hope this helps. Have a GREAT day ahead! Thank you zero_decimal_support.jrxml

Issue Description:How to show any column's decimal places digit dynamically using server attribute value from Jasperserver UI. For example, If we set 3 in Attribute Property then column value should be (124.000) else if we set 2 then column values should be (124.00). Currently for any column this is static setting i.e click on column >>Text Field => Pattern => Currency. ============================================================================== Resolution:We can create a dynamic numeric pattern expression based on the server attribute. You will need to follow below steps to achieve. 1) You will need to create two new parameters in your studio reports. Parameter a) Create this parameter with name "ServerAttribute_NoOfDecimals" . (NoOfDecimals is the name of your server attribute on your Jasperserver UI, and here we are adding "ServerAttribute_" as the prefix to this name.) Parameter b) Create this parameter with name "DecimalPattern" and under default value expression add below expression. ------------------------------ "¤#,##0." + String.format("%0" + $P{ServerAttribute_NoOfDecimals} + "d", 0) + ";¤(#,##0."+ String.format("%0"+ $P{ServerAttribute_NoOfDecimals} + "d", 0) + "-)"------------------------------ (This expression need to be changed as per your pattern selection from Text Field => Pattern => Currency . ============================= 2) Now click on "Text Field" where you want to add this pattern i.e in your case click on "Amount" Column text field and under pattern expression select "$P{DecimalPattern}" then save and publish the report to server. 3) This will then take the decimal value stored in your server attribute from UI dynamically. Hope this helps. Have a GREAT day ahead! Thank you report_1.jrxml

Issue Description:Usually customer add additional loggers explicitly under the black space present in Log Settings tab to analyze and debug the issues specific to component which are not already present in Log Settings. But going further when issue get resolves they require to remove this added extra loggers to not compromise on performance and to avoid extra loggers to get captured in log files. But , for some of the loggers added which has prefix with "com.jaspersoft....". then this loggers are not present with the same name in Restore default while deleting this loggers. For example , When you added loggers as below . com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobcom.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImplcom.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl Resolution: To remove this added extra loggers under the log settings tab , You will need to navigate to Manage >> Server Settings >> Restore default and search for below loggers and delete and click on the save button present on bottom left corner. log4j.com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJoblog4j.com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpllog4j.com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl Here, log4j is getting appended as the prefix for some of the extra loggers added. There is no need to restart the Jasperserver server as this changes get applied on fly. Hope this helps. Have a GREAT day ahead! Thank you

Issue Description:Usually customer add additional loggers explicitly under the black space present in Log Settings tab to analyze and debug the issues specific to component which are not already present in Log Settings. But going further when issue get resolves they require to remove this added extra loggers to not compromise on performance and to avoid extra loggers to get captured in log files. Resolution: To remove the added extra loggers under the log settings tab , You will need to navigate to Manage >> Server Settings >> Restore default and then delete your added loggers present on this page and click on the save button present on bottom left corner. There is no need to restart the Jasperserver server as this changes get applied on fly. Hope this helps. Have a GREAT day ahead! Thank you

Issue Description:Sometime customer usually want to use CURL commands to login to Jasperserver and export the reports present under repository structure of Jasperserver and store exported file in our local file system. Resolution: I have tested using below two commands for exporting sample report present under JRS repository location .../public/Samples/Reports/AllAccounts.csv Here I have used internal user i.e superuser and with no any external authentication setup. ------ Step 1: curl --verbose -c cookies.txt "http://localhost:8084/jasperserver-pro/rest_v2/login?j_username=superuser&j_password=superuser" This will help to use login service and store SessionID in cookie.txt file, You will need to add URL in double quote " " as mentioned above because & present in login argument is considered as an operator by shell if not mentioned under " ". ----- Step 2: curl -b cookies.txt http://localhost:8084/jasperserver-pro/rest_v2/reports/public/Samples/Reports/AllAccounts.csv -o "C:\Users\Desktop\test.csv" --verbose This will help to use session ID stored in cookies.txt file and download the report and store the export in location ..C:\Users\Desktop\test.csv. you will need to give your desired location which is accessible..

Issue Description:Usually customer creates their own custom font and they need this font to be set as default font to be used by Jasperserver reports. Resolution: >> To add custom font for your report as the default font , please open source of your report and add below line and save the reports. Here "Arial_Custom" is the custom font created and you will need to replace with your own font name. <style name="DefaultFont" isDefault="true" fontName="Arial_Custom"/> -- If this works fine on Studio , we will need to re-publish this reports to Jasperserver and add Custom Font JAR file under..Tomcat9webappsjasperserver-proWEB-INFlib and restart the server to make this reflected to Jaserserver. ------ Hope this helps.

Issue Description:Customer usually wants to add '$' symbol as the prefix of Adhoc view label's. Resolution: This can be achieved by adding property in Advance property section of Adhoc view editor mode. >>Open Adhoc Design editor view. >> Under Fornat Visualization section and under Advance add new property. >> Name as "yAxis.labels.format" and value as "${value:,0f}". ------ Hope this helps. --

Issue Description:When using the charts in adhoc view , Y-axis (Label) values are shown in 'k' i.e 5000 is represented as 5k , But sometime customer what's the value which is present in their data instead of default conversion to k. Resolution: This can be achieved by adding property in Advance property section of Adhoc view editor mode. >>Open Adhoc Design editor view. >> Under Fornat Visualization section and under Advance add new property. >> Name as "yAxis.labels.format" and value as "{value:,0f}". ------ Hope this helps. --

Issue Description:Sometime customer requires to rotate the log files of Jasperserver for better monitoring of their system based on the file size of the Japserserver.log file or to increase/decrease the size limit of Jasperserver log file to be stored. Resolution: This can be achieved to change the default file size limit of Jasperserver log by modifying log4j2.properties file present under ..Tomcat9webappsjasperserver-proWEB-INF file. Search for appender key value pair as per below. This states max size of the Japserserver log file is 1024KB. appender.fileout.policies.size.size=1024KB---- You can change as per your filesize requirement from KB to MB, GB or change the value as per requirement, save the file and restart the server. ----- Hope this helps, Thank you

Issue Description:Sometime customer require to change the directory /folder where the default Jasperserver.log file is stored. Resolution: To change the default Jasperserver.log file you will need to modify log4j2.properties file present under ..Tomcat9webappsjasperserver-proWEB-INF file and change the file as per below. Search for appender key value pair as per below and comment out. #appender.fileout.fileName=${log4j:configParentLocation}/logs/jasperserver.log Add new key value pair as per your new directory/folder requirement. appender.fileout.fileName=${sys:catalina.home}/logs/jasperserver.log (Here Jasperserver.log file gets stored in new folder ..Tomcat9logs ) ----- Hope this helps, Thank you

Issue Description:When you have more than 5000 folders present in the repository and when you try to browse and select folders while scheduling the report only 5000 folder list is shown and all other are hidden , Thus to make all other folder visible you will need to make configuration change as per below. Resolution: 1) Open file applicationContext-settings.xml under folder ..webappsjasperserver-proWEB-INF: 2) Search for code: <entry key="treeLevelLimit"> <value>5000</value> </entry> treeLevelLimit. 3) You can change its value to control the limit of items for the tree level based on your requirement. It affects all trees in JRS, so all trees have the same limit. Default value is 5000 items per level.

Issue Description: There is a need to restrict access to 'Save/Save As' button based on user role in TIBCO JasperReports® Server. ========================================================================================== Resolution: This would require some customization of JSP files. In short, you'll have to open this file WEB-INFjspmodulesviewReport and add below line to the top: <%@ taglib prefix="authz" uri="http://www.springframework.org/security/tags" %> Then, search in that file for this line: <li class="leaf"> <button id="fileOptions" class="button capsule mutton up first" title="<spring:message code="button.save"/>" disabled="true"> <span class="wrap"> <span class="icon"> </span> <span class="indicator"> </span> </span> </button> </li> and wrap this tag around it: <authz:authorize access="!hasAnyRole('ROLE_USER')"> ... .. </authz:authorize> ----------------- You can refer below Jasperserver Ultimate Guide for more details. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v750/restricting-access-role Hope this helps