sanbez
-
Posts
296 -
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 sanbez
-
1. >> Result is fine but with data have many record is result fine yet Is it means that all fine? "is fine but... fine yet" : why "but" if all fine? 2. >> new BigDecimal.setScale(2,ROUND_HULF_UP) This operation always return 20.05 not 20.0499999999997 Check your report. What are you show in report? Are you sure that it is result of setScale?
-
Try to use BigDecimal.setScale instead Math.round For example as here: public static double round(double value, int decimalPlace) { return new BigDecimal(value).setScale(decimalPlace, BigDecimal.ROUND_HALF_UP).doubleValue(); } May be it solve your problem. Welcome to the world of java-computing :))
-
Is export wrote on java? Then exporter = new CustomExcelExporter(file); exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, true);
-
Why table placed into ColumnHeader but not in Summary band?
-
In ireport select static text "Ganesh" and in Property Window (Ctrl+Shift+7) set Height=21 (or more then21). fontSize="18" does not fit in height=14 for this label. P.S. new Boolean($V{countNumber}.intValue() % 1 == 0 is always TRUE :D
-
http://community.jaspersoft.com/questions/521335/crosstabs-total-calculation
-
Nobody can't help you without information about problem. "but it is showing me null" - it is not enough to determine the error. Create new answer with description of problem. SHOW YOUR JRXML, define database (is it Oracle? Postgress, MSSQL? or is it JRBeanCollectionDataSource?...). Show version iReport (JasperServer?) After that you get a chance to get answer
-
when am going to generate pdf i got this error. anyone you can help me
sanbez replied to udumanajmeer's topic in Products
groovy-all-1.7.5.jar does not contain the class org/codehaus/groovy/runtime/BytecodeInterface8 Check libraries used for compiling report (or groovy-x.y.z.jar in tomcat?) http://stackoverflow.com/questions/7800930/error-when-deploying-grails-app-java-lang-noclassdeffounderror-org-codehaus-gr -
Show your java-code which make export to excel
-
Make jar with fonts (in iReport) and add this jar into project See more information in: http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/
-
iReport is not a database. It's only dispaly existing information. You lost information about previous day... In any moment you have info about only one day. I think about two ways to solve problem: 1. Change script on server with aim to save information for three last days. May be add date field in table with type of date (for save day: 13.05.2013, 14.05.2013, ...). And change report.jrxml for using this date. or 2. Make every day export data from existing report into csv (or excel? other file?). And make second report2 with this data source. But in this case you must to do:a) add system date (for example) to report as a parameter (or variable)b) aggregate data in one file (?)c) design report2.jrxml The first way is easier (imho)Maybe someone else will give advice...
-
Generate a Report with a List, Error retrieving field value from bean
sanbez replied to silvana.maissen's topic in Products
I am guess that daten is a list of geraet. Two ways for solution: 1. Change getter for gueltigbis from "getGueltigBis()" (now) to "getGueltigbis()" - it must match field name in jrxml (case-sensitive) or 2 Change field "gueltigbis" to "gueltigBis" in jrxml -
In linechart one axis (low for example) - is scale of Date (or Time?). In other Axis (Left) - scale of values. How you want to fit dates 13.05.2013, 14.05.2013, 15.05.2013 in one low axis??? This dates are located one after another on low axis...
-
You mix different fields from different tables in one SQL-query. It is not problem of iReport. It is problem to make correct query. Read documentation about basic concepts of SQL. For example: http://databases.about.com/od/sql/l/aajoins2.htm http://databases.about.com/od/sql/a/multiple_joins.htm
-
Question is not clear. Have you made attempt to disign report or not? Are you see data in report? Which DataSource is used (SQL-query, JRBeanCollectonDataSource, XML) ?
-
I am not sure, but try to make this: 1. Make alias for second (may be third) field: select ('PREGUNTA 1') as preguntas, pregunta_1 as pregunta_1, count(*) as cnt from form_app_001 union all ... 2. Set sort field preguntas and pregunta_1 in iReport ("Sort options" button in iReport) HTH
-
It's very strange. May be you have another not empty fields in left or right side near pies? And this prevents to reducing space. It's need to see your jrxml... Sorry, my work time is over. I am can to participate in forum only 13.05.2013.
-
Are you set "Remove line when blank" check-box in property of chart?
-
Telepathists is gone to vacation. Which database? Which JDBC url? Are you test JDBC-connection in iReport?
-
Pattern: #,##0.00;(-#,##0.00) and don't use conditional style. It is not need in this simple case
-
Generate a Report with a List, Error retrieving field value from bean
sanbez replied to silvana.maissen's topic in Products
Show your bean (daten) and jrxml. You should check getter for "gueltigbis" -
[Solved] OR operator in "Print when expression" field
sanbez replied to g.dagostino's topic in Products
Try like this: ($F{FIRST} != null && !$F{FIRST}.equals(""))||($F{SECOND} != null && !$F{SECOND}.equals("")) -
List list = new ArrayList(); list.add("one"); list.add("two"); list.add("three"); System.out.println(list.toString().replace(',', '|'));
-
Set in main report properties for subreport: Connection Type = Use a datasource expression Data Source Expression = (like this:)new JRBeanCollectionDataSource(myCollection) Check that you don't put DataSourceExpression into "ConnectionType" (see yuor error): net.sf.jasperreports.engine.data.JRBeanCollectionDataSource cannot be cast to java.sql.Connection
-
Clarify your question. Put part of xml and picture desired report
