aashnanahar

Try using color coding in your query based on the data example: CASE WHEN record_status_count.rcrd_stts_cd = 'ACPT' THEN '#007480' WHEN record_status_count.rcrd_stts_cd = 'RJCT' THEN '#8E1537' WHEN record_status_count.rcrd_stts_cd = 'PART' THEN '#E17D00' WHEN record_status_count.rcrd_stts_cd = 'RCVD' THEN '#8F489A' WHEN record_status_count.rcrd_stts_cd = 'EXTR' THEN '#76777B' WHEN record_status_count.rcrd_stts_cd = 'CRPT' THEN '#7BAED4' WHEN record_status_count.rcrd_stts_cd = 'WARN' THEN '#BBBBBB' WHEN record_status_count.rcrd_stts_cd = 'PDNG' THEN '#20345C' END AS color Add expression to your color pallete: example:java.util.Arrays.asList("#FFFFFF","#8E1537","#20345C","#8F489A","#E17D00","#007480","#76777B","#7BAED4","#BBBBBB","#3F3F3F","#C20430", "#e1c1c0","#d6f1f3","#B4CDB4","#ff6666","#C39BD3","#12d5ff","#83B43D","#CEC6FF","#ABB2B9","#6666ff","#ff99ff","#46614b","#be2337") add the color filed to the chart data configuration. Let me know if you need more help!!

Hi Anis, Try this: 1. Click on your Crosstab and go to the properties tab : Crosstab 2. Change Ignore Width to True. 3. on Apperance Tab: Stretch Type : Relative to Band Height

Hi All, I am working with cross tabs here ,I have 6 crosstabs placed in different detail band but when published on jasperserver it throws "Not enough space to render the crosstab error". So to overcome that I put those crosstabs in 6 different subreports summary band and published the same. But the error still persists. Please help!! I have streched the height of summay band to 595 px and subreport calling that summary band is placed in detail band of height 650 px. Error Message: Not enough space to render the crosstab.Error Tracenet.sf.jasperreports.engine.JRRuntimeException: Not enough space to render the crosstab. at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.fillVerticalCrosstab(JRFillCrosstab.java:1517) at net.sf.jasperreports.engine.fill.JRFillCrosstab$CrosstabFiller.fillVerticalCrosstab(JRFillCrosstab.java:1607) at

Hi ALL, has anybody tackled this scenario before...please help

I need to display 中国外汇交易中心（全国银行间同业拆借中心）type of characters in my input control value field. Chinese characters will be retrieved from a database table. Currently Jasper server displays blank for such characters. Please let me know why it is not allowing Chinese characters as the validation.properties has the RegEx pattern like '^[\p{L}\p{M}]*$' and # p{L} = allow letters any language.

On Apache Tomcat the encryption of password can be easily achieved by following steps: 1. change the encryption tag to true in default_master.properties. encrypt=true 2. From command prompt run the below command: C:Jaspersoftjasperreports-server-6.3.0buildomatic> js-ant refresh-config this will give you the encrypted password in default_master.properties. 3. Replace that password with the plain text password in C:Jaspersoftjasperreports-server-6.3.0apache-tomcatwebappsjasperserver-proMETA-INFcontext.xml. username="postgres" password="ENC-c7a3834ea09b0c47dc9ea00cc390222bb3965623bcbe960ca73899be5ed3a020-" Make sure the username and password in both the files(default_master.properties and context.xml) should be same. Create and entry in C:Jaspersoftjasperreports-server-6.3.0apache-tomcatwebappsjasperserver-proWEB-INFweb.xml in case of an external db configuration. <resource-ref> <description>My Database database</description> <res-ref-name>jdbc/newdb</res-ref-name> <res-type>javax.sql.ConnectionPoolDataSource</res-type> <res-auth>Container</res-auth> </resource-ref>4. start and stop the tomcat server and you are all set.

Hi Team, I followed the below steps to get the encryption turned on : 1. Go to your Jaspersoft Install files: $jasper_installjasperreports-server-5.6.1-binbuildomaticdefault_master.properties 2. Enter the correct value for Jasper DB Password in plain text 3. Ensure all other values are still valid, such as Tomcat directory etc. 4. Change the encrypt.done=true to encrypt=true 5. Save the file. 6. Now navigate to $jasper_installjasperreports-server-5.6.1-binbuildomatic 7. Run the command: js-ant refresh-config This will remove and recreate all the configuration files without deploying them to the application server. I was able to get the password encrypted in context.xml located at $jasper_installjasperreports-server-5.6.1-binbuildomaticbuild_confdefaultwebappMETA-INF and I copied the same to my tomact directory $JSTomcatwebappsreportserviceMETA-INFcontext.xml and restarted the server. After that I am not able to access the homepage.(http://localhost:8080/jasperserver/home.html) It gives me HTTP Status 404 Error. There are no error in the logs and below is the snippet from my context.xml <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="postgres" password="ENC-80d75f96110c52d1b163b2a3838cb8bb3d643a4a6fa65e1812be0e258846952d-" driverClassName="org.postgresql.Driver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:postgresql://127.0.0.1:5432/jasperserver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" />server.xml: </GlobalNamingResources> <Service name="Catalina"> <Connector port="8080" URIEncoding="UTF-8" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" scheme="http" secure="false" keystoreFile="D:/Users/aaashna/.keystore" keystorePass="changeit"/>

Hi All, I have customized a cross tab report.I need help in consolidating the data in one a single detail section of the crosstab, please refer the screenshot attached The desired report should look like the below : No. of PoliciesNo. of LivesGross PremiumChannelCH0110001800$200,000 Branch1250500$50,000 ProductA100250$20,000 ProductB75100$15,000 ProductC75150$15,000 Branch27501300$150,000 ProductD5001000$100,000 ProductE250300$50,000 Please let me know the solution to this.