Subramanian Meyyappan

i gave a look to those thread . it's help me. subtracting two variable total fields in ireport error compiling BigDecimal values

As Far As i Know, if it says document has no pages means, query does't return any data's

hi experts, using ireport3.0.0.i want to subtract two number. i created a variable named CloseBal.in variable expersion i wrote like this. $F{DEBIT_AMOUNT} - $F{CREDIT_AMOUNT} but the while compiling The Operator - is undefined for the argument type(s)java.math.bigDecimal,java.math.bigDecimal Line 218 column 23 /jasperReport/variable[3]/variableExperssion[1] in my fields Section DEBIT_AMOUNT and CREDIT_AMOUNT both of the fields is of java.lang.BigDecimal some more info. net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. The operator - is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal value = (java.math.BigDecimal)(((java.math.BigDecimal)field_DEBIT_AMOUNT.getValue())- ((java.math.BigDecimal)field_CREDIT_AMOUNT.getValue()));//$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------> 2. The operator - is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal value = (java.math.BigDecimal)(((java.math.BigDecimal)field_DEBIT_AMOUNT.getOldValue())- ((java.math.BigDecimal)field_CREDIT_AMOUNT.getOldValue()));//$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------> 3. The operator - is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal value = (java.math.BigDecimal)(((java.math.BigDecimal)field_DEBIT_AMOUNT.getValue())- ((java.math.BigDecimal)field_CREDIT_AMOUNT.getValue()));//$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------> 3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:591) at java.lang.Thread.run(Unknown Source) could any one help me where am ? Post Edited by adfpeoples at 05/28/2012 06:33

can any one give some ideas, today also same problem persist.

hi friend, from my experiences while playing with bands, we have to careful. As far As I know, sometimes bands move away from the place a bit, means output(report) may not renders

hi friend, by increasing height of band you can to do that

hi friend. there are 12 kind of preview available in ireport 3.0.0 what kind of preview are you using? could you please mention the version..

hi experts, am using ireport 3.0.0. i had problem problem description: report query wizard: showing following Error: General problem:9 Check username and password; is the DBMS active?! but while running: Compiling to file... C:Documents and SettingsAdministratorDesktopxx3050.jasper -> C:Documents and SettingsAdministratorDesktopAPM3050.java Compilation running time: 125. Filling report... Locale: English (United States) Time zone: Default Error filling print... 9 java.lang.ArrayIndexOutOfBoundsException: 9 at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:745) at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:551) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1078) at oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:24) at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:71) at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:770) at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:672) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:162) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:123) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1196) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:833) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:782) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:947) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource... yesterday i doesnt had such kind but today like this kind as such. some months ago i had this same problem. but it recover automatically. i did't do any anything. but now same problem persist. my db is in another machine i can able to ping the db and i also check the test connection in ireport it prompt test connection succesfull. could any one help me. to solve my problem.

CAN YOU SEND ME EXAMPLE REPORT BASED ON THIS NO DATA.

THANK THANKS A LOT. BUT I TRIED AS YOU SAID. BUT IT DISPLAY'S NOTHING. I PUT STATIC TEXT INTO YOUR MY REPORT AND DRAG AND DROP THE STATIC TEXT INTO NO DATA SECTION. IN THAT STATIC TEXT I WROTE "NO DATA" AND GO TO EDIT AND OPEN REPORT PROPERTIES GO TO MORE SECTION IN THAT LAST WHEN NO DATA THERE IS A DROP DOWN I CHOOSE NO-DATA SECTION. I HAD 7 OR 8 PARAMATERS . I WILL FILL ALL THOSE AS EMPTY. AND RUN MY REPORT IT DOESNT SHOW'S THE TEXT WHAT I WHAT. SORRY TO TROUBLING YOU. AM ENTIRELY NEW IREPORT

yes, left side i found out the nodata band height i give it as '5' and check split allowed if i give anything to print when expersion menas it throws some. if i not give anything means looks good. but it's not printing nodata. i want to write anything print when expersion if so means. can you show the example.

above requirement is this possble ireports? i want to group two or three fields as group show in each header of the page. Post Edited by adfpeoples at 03/23/2012 09:37

can you mention where is it?

using ireport3.0.0 hi groups, gud noon fine. Using jdev 11.1.1.5.0-adfbc-oracledb10g-mozilla ffx9.0.1 - jasper with the help these am running my report in pdf. if data matches means report runns, ok. if it not matches. pdf opens as empty. instead of opening empty. i want to show no datas are present msg or else give print ' - (hyphen) ' all of the fields which shown in report how to do that? here am to represent more in detail. if anyone need ? Post Edited by adfpeoples at 03/20/2012 08:44

hi experts, am using jdevloper11.1.1.5.0-ireports iReport 3.0.0 © 2002-2008 by JasperSoft Corp. am somewhat new to ireports. here is sample requirement in pdf see this pics: http://imageshack.us/photo/my-images/21/63169969.png/ in above pics, here two units are showing. ok. this is my main requirement. but In my ireport output if am showing one unit means report is ok see the pics. http://imageshack.us/photo/my-images/401/36985164.png/ or else it seems to be horrible.. see the pics. http://imageshack.us/photo/my-images/839/77792564.png/ here two units records showing as am developer so i know. but from thought of end user. he/she doesnt know. atlast i found out the reason. i did not use the grouping option..ok i forget utilizse the grouping option Reason for posting here : without re-drawing this report(from starting onwards).is there any option? group those things as my original pdf requirement can anyone show me the ways..