emrizwan

I've resolved this. the solution is set the measure function to SUM instead of Nothing thanks

Hi, Im using ireport 4.0.1. I am having issues with calculating grand totals in a cross tab report. the below report is for fee receipt per payment mode eg, Cash (CA), Card (CD), Cheque (CH) & direct debit (DD). I've used default option of calculating sum by selecting 'Add row group total' row group = Receipt number, column group = receipt payment mode measure = receipt amount (Function = Nothing) as you can see the report totals are not correct, please can you help how can I calculate correct totals? I've tried using variable $V{receipt_amountMeasure_receipt_payment_mode_ALL} but its still correct. Thanks

Hi, I've created a parameter called paramValue and added to mysql query as below. when I am running my report, its throwing following error. ( I am adding "and 1=1" on prompt) net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: AttendanceSheet. at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:511) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:486) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:367) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: AttendanceSheet. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:342) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:523) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" and 1 = 1 " order by ce.course_id, sn.session_id' at line 17 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source I've used ireport 4 version but did'nt have this issue there. please can you help on how to resolve this in version 6.1.1? thanks

Hi Rajesh, The data type of my columns are Decimal so I am using following expression in step 3 of your post. IF(DECIMAL_VALUE($F{txn_cr})==0,-DECIMAL_VALUE($F{txn_dr}),DECIMAL_VALUE($F{txn_cr})) when I run the report it throws below error Error filling print... Error evaluating expression : Source text : IF(DECIMAL_VALUE($F{txn_cr})==0,-DECIMAL_VALUE($F{txn_dr}),DECIMAL_VALUE($F{txn_cr})) net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : IF(DECIMAL_VALUE($F{txn_cr})==0,-DECIMAL_VALUE($F{txn_dr}),DECIMAL_VALUE($F{txn_cr})) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:259) at net.sf.jasperreports.engine.fill.JRCalculator.evaluateEstimated(JRCalculator.java:580) Please can you advise? thanks

I've found a workaroun for this where I don't need to install report server. I've created a parameter pImagePath and set the image expression property as $P{pImagePath}. From my web application (ADF application) I am passing value to this variable as filePath=FacesContext.getCurrentInstance().getExternalContext().getRealPath("/images/company_logo.png"); and in the reprt paramaters. m.put("pImagePath",filePath); hope this helps.

Hi, I am using ireport 4. I've created a report with an image. this image is located at my local C drive. I am calling this report from a web application. How can I set the image path to look at my applications root and not from my local machine? thanks

Hi, I am using ireport 4 configured to run from a java application. I've created a report using the Calibiri Font. It looks ok when I run it in pdf preview. But when I run it from my application the font changed to Arial. please can you advise if I am missing something? thanks

I've found the solution to this the parameter should be defined as, $P! $P!{my_query} Refer to below link for more details http://community.jaspersoft.com/wiki/using-report-parameters

I am using ireport 4.0 and want to create mail merge style report. the required format looks like this <student id><student name><student address>Dear parent,There is an outstanding balance of <balance_amount> which needs to be paid by <balance_date>....................................................................................................................................................................................................<student id><student name><student address>Dear parent,There is an outstanding balance of <balance_amount> which needs tobe paid by <balance_date>.................................................................................................................................................................................................... any ideas, how can i create such report?

Hi, I want to create a report with below format opening bal: 50DatePaind InPaid OutBalance01/01/15100 15002/01/15 4011003/01/15200 310 Please can you help on how a report with such a format can be created using ireport? thanks

Hi Vitaace, you have mentioned to add student_id, student_name and class in the Row Group "Choose student_id, student_name and class for Rows (set None for Total Position for all fields)." I am using ireport version - "Product Version: Jaspersoft iReport Designer 4.0." which only allows to choose 1 column (as shown) in the Row Group is there any other version of ireports which allows to add more than one columns in a Row Group? thanks

Hi, is it possible to pass a query string as a parmeter to a report? for instance, I have a sql like select * from employees <lexical parameter> and in this parmeter space, I pass string value as "where dept_id = 25 and location_id = 1" any ideas? thanks

Hi, I want to create a cross tab report with multiple row columns as below Student DetailsMonthStudent idStudent NameclassJanFebMarch1abcclass 12525252xyzclass22500the report is to get details of student fees which have been received every month. real report will have details of all 12 months. I can create simple report with Student Id, Month and Amount columns but I also want other details such as student name, Class Name etc. any ideas? thanks