Rutuja Bhalchandra Shinde

Description :This wiki article demonstrates how to change the color of the warning message getting displayed below the mandatory input controls by editing the theme. Resolution :1) To change the color of the mandatory input control warning message you will need to create a new theme. 2) To create a new theme, go to the repository and right-click Theme, and click 'Add Folder' 3) Name the folder - 'New Theme' (or whatever is fine by you) 4) Now, create a CSS file called - 'overrides_custom' 5) In the CSS file add the below commands - .palette17, .warning, .errorMessage, .invalid>.wrap, .error>.message.warning a.details:active { color: #062e79; } (set the color as per your requirement) 6) Save the file and open the repository in Jasperserver. 7) In the new folder 'New Theme' right-click and Add Resource-->File-->CSS 8) Add the CSS file - 'overrides_custom' and set it as an Active theme 9) Now log out and log in again to see the changes. Before : After : overrides_custom_6.css

Overview:In this article, we will demonstrate the steps required to create a relative date parameter. In this article, we will create a date+1 relative parameter. Resolution :To create a relative date parameter you will need to create an input control as below in the report using Jaspersoft studio. - In the studio open the report where you want to have date + 1 default parameter and create the parameter as below. You can define input control as follows and The input control will be initialized with the respective parameter defaultvalueexpression. <parameter name="sysdate" class="net.sf.jasperreports.types.date.DateRange"> <defaultValueExpression><![CDATA[new net.sf.jasperreports.types.date.DateRangeBuilder("DAY+1").toDateRange()]]></defaultValueExpression> </parameter> You can use these parameters in the query in conjunction with $X, e.g. $X{EQUAL,date,sysdate} - After adding the input control publish the report on the jasperserver. - Run the same report on the jasperserver in the input control tab you will get the default date+1 parameter. - In the same way, you could create a date-1 parameter as well. date.jrxml

Overview: In this article, we will demonstrate the steps required to show Text/logo dynamically based on logged-in users. Resolution :Please refer to the below steps to display logo and text dynamically based on logged-in users : - First, you will need to create a parameter for logged-in users like below : <parameter name="LoggedInUsername" class="java.lang.String" isForPrompting="false"/> - Then select the logo or text, then go to the properties tab. - In the print when expression box, provide the expression based on your requirement with the use of $P{LoggedInUsername} For example : $P{LoggedInUsername}.equals( "jasperadmin" )

Resolution :If you want to use a Jboss Application server for the jasperserver installation and want to use a profile other than the default, please refer to the below step to configure the non-default profile before running the js-install script. Step 1: Open the below property file jasperreports-server-pro-8.0.0-bin/buildomatic/conf_source/templates/app.srv.properties Step 2 : Then change the jboss7.profile property as per below : From : # jboss 7 profile jboss7.profile = standalone To: # jboss 7 profile jboss7.profile = <your_profile_path>

Description :After applying the security patch on JasperReports Server customer faced the "Invalid license. License file jasperserver.license is corrupt." issue. Resolution : For JBoss and Wildfly application servers, it is also required to change the reference of Log4j jar versions in jboss-deployment-structure.xml - open jboss-deployment-structure.xml which will find under jbossstandalonedeploymentsjasperserver-pro.warMETA-INF - You will find below log4j jar reference in the jboss-deployment-structure.xml file <resource-root path="WEB-INF/lib/log4j-web-2.13.3.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-slf4j-impl-2.13.3.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-jul-2.13.3.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-jcl-2.13.3.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-core-2.13.3.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-api-2.13.3.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-1.2-api-2.13.3.jar" use-physical-code-source="true"/> - Please update the log4j jar versions references as per below in jboss-deployment-structure.xml file <resource-root path="WEB-INF/lib/log4j-web-2.17.0.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-slf4j-impl-2.17.0.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-jul-2.17.0.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-jcl-2.17.0.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-core-2.17.0.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-api-2.17.0.jar" use-physical-code-source="true"/> <resource-root path="WEB-INF/lib/log4j-1.2-api-2.17.0.jar" use-physical-code-source="true"/> - save the file and restart the application server

Overview:In this article, we will demonstrate the steps required to connect snowflake as a data source. ----------------------------------------------------------------------------------------- Solution:- Log in to Jasperserver UI, select create -> data source. - select the JDBC driver as "other" - Enter the name of the JDBC driver "net.snowflake.client.jdbc.SnowflakeDriver" - select the Add jar option and add the appropriate jar file for the connection. The latest Snowflake JDBC driver is downloadable here: https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc - Enter the URL. for ex: jdbc:snowflake://<snowflake_host>/?user=<username>&role=<role>&warehouse=<warehouse_name>&db=<test>&schema=PUBLIC&tracing=ALL - Enter the valid username and password and Test the connection. - Then save Datasource by giving the name under the required folder.

Overview:In this article, we will demonstrate the steps required to connect snowflake as a data source. ------------------------------------------------------------------------------------------- Solution:- Right-click on Data Adapters -> Click on Create Data Adapter - Select Database JDBC connection. - Enter name of the JDBC driver "net.snowflake.client.jdbc.SnowflakeDriver" - Enter the URL. for ex: jdbc:snowflake://<snowflake_host>/?user=<username>&role=<role>&warehouse=<warehouse_name>&db=<test>&schema=PUBLIC&tracing=ALL - select Driver class path -> select Add and add the appropriate jar file for the connection. - Test the connection and save Datasource. ------------------------------------------------------------------------------------------------- The latest Snowflake JDBC driver is downloadable here: https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc

Description:In this article, we will demonstrate how to upload the main report and subreport separately and how to connect the main report and subreport on the JasperReports® Server. Resolution:Step 1: Add the main report to the JasperReports Server using below Rest callMethod : Post URL : http://<host>:<port>/jasperserver-pro/rest_v2/resources/<folder Path> Content-Type : application/repository.reportUnit+json { "uri": "(resource uri)", "label": "sample label", "permissionMask": "0", "version": 0, "dataSource": { "dataSourceReference": { "uri": "(datasource uri)" } }, "jrxml": { "jrxmlFile": { "label": "main_jrxml", "type": "jrxml", "content":"{base64EncodedContent}" } } } Step 2: Add the Subreport to the JasperReports Server using the below Rest call Method : Post URL : http://<host>:<port>/jasperserver-pro/rest_v2/resources/<folder Path> Content-Type : application/repository.reportUnit+json { "type":"jrxml", "label":"sample label", "content":"{base64EncodedContent}" }Step 3Go to the JasperReports Server. Edit the main report. Select controls and resources -> resources -> Add resources -> select resource from the repository Browse the location of the subreport, click next give the name to the subreport as per the given in the main report. For example, in the main report subreport name is "sub.jrxml" then add name as a sub.jrxml. Save the changes and then run the main report.

DescriptionIn this article, we will demonstrate how to add a new data format to display numbers up to four decimal places in the data presentation tab while creating a domain. ResolutionTo add custom data format to be shown as default as part of data formats dropdown in the data presentation tab You need to add a new data format in the adhoc_masks_client.properties file which will find under <Tomcat>webappsjasperserver-proWEB-INFbundles Edit the adhoc_masks_client.properties file, add the below in key ADH_100_MASK_dec_4 to display numbers up to four decimal places. ADH_100_MASK_dec_0 = 0,0.00 ADH_100_MASK_dec_1 = 0 ADH_100_MASK_dec_2 = ($0,0.00) ADH_100_MASK_dec_3 = ($0,0) ADH_100_MASK_dec_4 = 0,0.0000Save the changes and restart the server. Once the server is restarted, you will be able to select the data format mask to display four decimal places. Note: Before making any changes in the files please keep a backup of all files.

To use the CMYK model for the generation of PDF reports, JasperReports Library supports PDF/A compliant export. There is a property to use ICC color profile, it is applicable when PDF/A compliance is enabled: #net.sf.jasperreports.export.pdfa.conformance #net.sf.jasperreports.export.pdfa.icc.profile.path Please refer to the following article to set the properties : https://community.jaspersoft.com/wiki/pdf-support-jasperreports-library TO download the ICC profile please use the below link : http://www.color.org/registry/PSOcoated_v3.xalter PDF/A option require fond embedding into Pdf document for that please refer the following link : https://community.jaspersoft.com/wiki/custom-font-font-extension cmyk.jrxml

Description :This article will cover the steps to enable SSL in tomcat for the JRS. Solution :1. Create a self signed certificate using OpenSSL. 2. create a folder in the <tomcat>/conf folder and put the certificate.pem, key.pem and certificate file in it. (here I have considered folder name as SSL) 3. Edit the <tomcat>/conf server.xml file and add the following : <Connector port="8443" protocol="org.apache.coyote.http11.Http11AprProtocol" maxThreads="150" SSLEnabled="true" > <UpgradeProtocol className="org.apache.coyote.http2.Http2Protocol" /> <SSLHostConfig> <Certificate certificateKeyFile="<Tomcat>/conf/SSL/key.pem" certificateFile="<Tomcat>/conf/SSL/certificate.pem" certificateKeystoreType="<certificate-Type>" certificateKeystorePassword="<password>" /> </SSLHostConfig> </Connector> 4. Save the changes and restart the server.

Issue Description :After applying a patch on JETL 7.3.1 customer could not open the studio and got a dialog box message stating see the configuration.log file. Solution :- To resolve the issue first you will need to re-install the JETL studio. - After complete installation Add the following parameter in the conf.ini file under studioconfiguration of the studio before applying the patch. "osgi.framework=file:plugins/org.eclipse.osgi_3.13.200.v20181130-2106.jar" - After adding the parameter, Apply the patch on the JETL studio. To apply the patch refer to the below documentation: https://help.talend.com/r/en-US/7.3/migration-upgrade-guide-big-data/applying-patch-to-talend-studio - After applying a patch, re-start the studio. Now the studio will be able to detect the latest patch and will be successfully able to open the studio. Note: This parameter must be added to all the fresh installations of the JETL 7.3.1 studio before applying any patches.

Description :This article will cover the steps to create a custom-calculated function in order to remove the extra space between text fields. Note: The above settings are made globally. You could use the calculated function in any Adhoc view and domain. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Resolution:Please refer to the below steps to create a calculated field that will Replace unwanted additional spaces : Step 1: Stop the application server. step 2: Add the function definition to WEB-INFapplicationContext-el-operators.xml <bean parent="functionDef"> <property name="name" value="SpaceReplace"/> <property name="javaType" value="java.lang.String"/> <property name="properties"> <map> <!-- show in calc field dialog --> <entry key="inAvailableFunctions" value="true"/> <!-- always run in SQL --> <entry key="alwaysInSQL" value="true"/> </map> </property> <property name="inMemory" value="false"/> </bean> step 3: Add the function definition to WEB-INFapplicationContext-semanticLayer.xml. Make sure to place the function under the correct bean that's reflect your database repository type. (In my case database repository is MYSQL) <entry key="SpaceReplace"> <value>"LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(" + sqlArgs[0] + ",CHAR(32),'()'),')(',''),'()',CHAR(32))))"</value> </entry> step 4: After all the changes are done, clear the temp folder and start the application server. Also, clear the browser cache. Step 5: In the Ad hoc view create a calculated field using the "SpaceReplace" function. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Note: Before making any changes in the files please keep a backup of all files. spacereplace_function.zip

Description : Under certain circumstances, customers have seen that when browsing default language is other than English and when they view a report in chrome or edge, the display position of the text field is misaligned. But when Browser language is default English then the text field of the report display as expected. ================================================================================= Resolution:To display the position of the text field correctly in a browser with a default language other than English perform the following settings: - In the chrome, open the 'chrome://settings/fonts' path. - By default 'Minimun font size' = '10' change the 'Minimum font size' to '0' - In the Edge, open the 'edge://settings/fonts' path. - By default 'Minimum font size' = '10' change the 'Minimum font size' to '0' - Also make sure that the browser version should be as below or more than that. Chrome(Version 91.0.4472.77) Edge (Version 92.0.902.55) =================================================================== Note: Solution is tested in JRS 7.8 with the Japanse as a default browser language.

Description :Under certain circumstances customers have seen Some of Adhoc view chart dashlets that are combined in dashboard are not finished rendering at the moment when the pdf is generated. Resolution :To render the Ad hoc view chart completely in schedule output add following property : open the Ad hoc view which is used in dashboard -> click on setting icon -> chart format -> Advance -> Add new property. Add the "plotOptions.series.animation" and its value to "false". save the changes and add modified Ad hoc view in dashboard. schedule the dashboard. Note :To generate graphical reports JasperReports Server uses the Chromium JavaScript engine that are run in the background or scheduled. You can use Chrome, Chromium, or any other browser based on Chromium like Microsoft Edge. To configure the JRS to support Graphical Report Rendering please refer the following documentation : https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/configuring-jasperreports-library#Configuring_a_JavaScript_Engine

Description :============================================================================================================================================= Cutomer with date as Input control want to display data of the report After the start date Input control. If the Database, JVM and JRS timezone is in same timezone. (for example : all three are in UTC) and user is located in other timezone (like : CST). And Users in other timezone than UTC are facing date - 1 result in report output then by setting following property you can avoid this behaviour. Resolution :=========================================================================================================================================== set the following property in jasperreport.properties file which will find under <Tomcat>webappsjasperserver-proWEB-INFclasses net.sf.jasperreports.jdbc.time.zone=REPORT_TIME_ZONEProperty specifying the default time zone to be used for sending and retrieving date/time values to and from the database. The property can be set globally, at dataset level, at parameter and field levels, and as a report/dataset parameter. This Property will disable offset conversion for java.sql.Date, java.sql.Timestamp, java.util.Date, etc. After setting propety Save the file. Restart the server and verify your report.