aashnanahar
-
Posts
8 -
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
Posts posted by aashnanahar
-
-
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 Trace
net.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 Policies No. of Lives Gross Premium Channel CH01 1000 1800 $200,000 Branch1 250 500 $50,000 ProductA 100 250 $20,000 ProductB 75 100 $15,000 ProductC 75 150 $15,000 Branch2 750 1300 $150,000 ProductD 500 1000 $100,000 ProductE 250 300 $50,000 Please let me know the solution to this.
how to change the tree map plot colors?
in Products
Posted
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!!