ktrinad

By: eric - greatmaster JasperReport and PHP 2003-10-23 03:59 Hello i would like to use the JasperReport API in my web site. How can i call this API with PHP? Do you know ressources to help me doing that ? thanks @+

By: Dhananjoy Kumar Singh - dhananjoysingh HOW TO CHANGE AMOUNT IN WORDS 2003-10-21 02:17 HI.. i m calculating total from some field and i have to diaplay that in words. suppose the total is 2,345 then i have to print "Two thousands three hundred forty five" do anybody have any suggestion thanks By: Giulio Toffoli - gt78 RE: HOW TO CHANGE AMOUNT IN WORDS 2003-10-21 04:20 write a java class that convert a number in words decaring it as follow: public Num2Words { static public String convert(double d) { String inWords = "zero"; ..... your code.... .... return inWords; } } Then in your textfield write an expression like: Num2Words.convert( $F{MyNumberField}) Be sure that the number is double. Set the class of the textfield to String. For the code to write a number in words, search on google. I don't have any idea. Giulio By: Mark Rhodes - mrhodes2 RE: HOW TO CHANGE AMOUNT IN WORDS 2003-10-21 09:26 Here is an SQL function I found. Create a user defined functions in master. To use function - select amount,master.dbo.numberswords(amount) from table CREATE function NumbersWords(@s VARCHAR(50)) --English words for numbers returns VARCHAR(1024) as BEGIN DECLARE @a char(1),@b char(1),@c char(1),@i int, @j int, @result VARCHAR(1024), @orlen int SET @orlen=LEN(@s) IF LEN(@s) % 3>0 SET @s=' '+@S IF LEN(@s) % 3>0 SET @s=' '+@S SET @i=1 SET @result='' IF LEN(@s)=1 AND @s='0' SET @result='zero' WHILE @i<=LEN(@s) BEGIN SET @j=LEN(@s)-@i+1 SET @a=substring(@s,@j,1) SET @b=substring(@s,@j-1,1) SET @c=substring(@s,@j-2,1) if isnumeric(@a)=1 BEGIN SET @result=case WHEN (@i-1=3) AND (@c+@b+@a<>'000') THEN 'thousand' WHEN (@i-1=6) AND (@c+@b+@a<>'000') THEN 'million' WHEN (@i-1=9) AND (@c+@b+@a<>'000') THEN 'billion' WHEN (@i-1=12) AND (@c+@b+@a<>'000') THEN 'trillion' WHEN (@i-1=15) AND (@c+@b+@a<>'000') THEN 'quadrillion' WHEN (@i-1=18) AND (@c+@b+@a<>'000') THEN 'quintillion' WHEN (@i-1=21) AND (@c+@b+@a<>'000') THEN 'sextillion' WHEN (@i-1=24) AND (@c+@b+@a<>'000') THEN 'septillion' WHEN (@i-1=27) AND (@c+@b+@a<>'000') THEN 'octillion' WHEN (@i-1=30) AND (@c+@b+@a<>'000') THEN 'nonillion' WHEN (@i-1=33) AND (@c+@b+@a<>'000') THEN 'decillion' WHEN (@i-1=36) AND (@c+@b+@a<>'000') THEN 'undecillion' WHEN (@i-1=39) AND (@c+@b+@a<>'000') THEN 'duodecillion' WHEN (@i-1=42) AND (@c+@b+@a<>'000') THEN 'tredecillion' WHEN (@i-1=45) AND (@c+@b+@a<>'000') THEN 'quattuordecillion' WHEN (@i-1=48) AND (@c+@b+@a<>'000') THEN 'quindecillion' WHEN (@i-1=51) AND (@c+@b+@a<>'000') THEN 'sexdecillion' WHEN (@i-1=54) AND (@c+@b+@a<>'000') THEN 'septendecillion' WHEN (@i-1=57) AND (@c+@b+@a<>'000') THEN 'octodecillion' WHEN (@i-1=60) THEN 'novemdecillion' ELSE '' END+' '+@result if @b!='1' OR @b=' ' SET @result=case @a WHEN '1' THEN 'one' WHEN '2' THEN 'two' WHEN '3' THEN 'three' WHEN '4' THEN 'four' WHEN '5' THEN 'five' WHEN '6' THEN 'six' WHEN '7' THEN 'seven' WHEN '8' THEN 'eight' WHEN '9' THEN 'nine' ELSE '' END+' '+@result if (isnumeric(@b)=1 )AND (@b!='0') IF @b='1' SET @result=case @a WHEN '0' THEN 'ten' WHEN '1' THEN 'eleven' WHEN '2' THEN 'twelve' WHEN '3' THEN 'thirteen' WHEN '4' THEN 'fourteen' WHEN '5' THEN 'fifteen' WHEN '6' THEN 'sixteen' WHEN '7' THEN 'seventeen' WHEN '8' THEN 'eighteen' WHEN '9' THEN 'nineteen' ELSE '' END+' '+@result ELSE SET @result=case @b WHEN '2' THEN 'twenty' WHEN '3' THEN 'thirty' WHEN '4' THEN 'fourty' WHEN '5' THEN 'fifty' WHEN '6' THEN 'sixty' WHEN '7' THEN 'seventy' WHEN '8' THEN 'eighty' WHEN '9' THEN 'ninety' ELSE '' END+' '+@result END if (isnumeric(@c)=1)AND (@c!='0') SET @result=case @c WHEN '1' THEN 'one' WHEN '2' THEN 'two' WHEN '3' THEN 'three' WHEN '4' THEN 'four' WHEN '5' THEN 'five' WHEN '6' THEN 'six' WHEN '7' THEN 'seven' WHEN '8' THEN 'eight' WHEN '9' THEN 'nine' ELSE '' END+' hundred'+' '+@result SET @i=@i+3 END SET @result=LTRIM(RTRIM(@result)) return @result END By: Dhananjoy Kumar Singh - dhananjoysingh RE: HOW TO CHANGE AMOUNT IN WORDS 2003-10-23 01:26 HI Giulio I GOT THE JAVA CLASS... BUT WHERE SHOULD I PUT THE CLASS FILE IN iReport folder. By: Dhananjoy Kumar Singh - dhananjoysingh RE: HOW TO CHANGE AMOUNT IN WORDS 2003-10-23 03:45 hi Giulio problem got solved ... i got the class from google and used that... it is working

By: T.Gopalakrishnan - gopal03 Generaic Text Mode 2003-10-21 00:28 How can i create Generic text report using iReport (i.e printout using Dot Matrix Printer).I tried with courier new font but it is not working.Can any one help me Thanks T.Gopalakrishnan By: Giulio Toffoli - gt78 RE: Generaic Text Mode 2003-10-21 04:23 You should write a new JasperExporter to export prints in txt format. Giulio By: T.Gopalakrishnan - gopal03 RE: Generaic Text Mode 2003-10-21 05:32 Thanks Giulio Toffoli I am new to iReport so can u please explain it little bit briefly T.Gopalakrishnan

By: Graham Lounder - glounder Basic Report and MS SQL Server 2003-10-21 04:30 I'm trying to run a report I generated with the wizard in iReport 0.2.2. Its a basic report which grabs one record and displays in on the page. I'm running this against MS SQL Server and I get the following error: Caused by: java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]ResultSet can not re-read row data for colu mn 30. I guess SQL Server only lets you read a value from a result set once. Has anyone seen this before? Cheers, Graham By: Giulio Toffoli - gt78 RE: Basic Report and MS SQL Server 2003-10-21 04:33 Yes, I have already seen, but only using JDBC-ODBC bridge. Use native JDBC driver to access SQL Server. This drivres are available on Microsoft site. Giulio By: Graham Lounder - glounder RE: Basic Report and MS SQL Server 2003-10-21 04:44 I've tried both the jdbc odbc bridge and the microsoft jdbc driver and can't seem to get them to work. Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver Connection String: jdbc:microsoft:sqlserver://mydbmachine:1433 Maybe there is something I can update in the code to fix this problem. I can't seem to find out where jasper is trying to access a column twice though. By: Graham Lounder - glounder RE: Basic Report and MS SQL Server 2003-10-21 05:10 I've sloved my problem. I found a an open source MS SQL Server driver called jtds and runs the report fine. I'll have to check out the performance but it looks like this will do the trick. By: Giulio Toffoli - gt78 RE: Basic Report and MS SQL Server 2003-10-21 05:10 Save the field in a variable and use it. But I have used SQL Server2000 many times and I don't have this problem. Giulio By: Giulio Toffoli - gt78 RE: Basic Report and MS SQL Server 2003-10-21 05:11 jtds is well used (I have used it too). Be sure of the version of your MS drivers. Giulio

By: Nemi Chandran - nemis_work Incrementing dates... 2003-10-17 13:06 Hi all... Is there a way to increment dates... I have retrived a 'java.util.Date' field from the database and i want to increment it and display in 6 different fields. Basically i get the first day of the week from a DB and i want to display all 7 dates of the week in my report. Thanks. By: Giulio Toffoli - gt78 RE: Incrementing dates... 2003-10-21 04:31 See this post to know how to add java code in your textfield. https://sourceforge.net/forum/forum.php?thread_id=955348&forum_id=217623

By: madhuri - madhuri_ls ireport-lpad 2003-10-17 22:47 formatting of the fields using lpad By: Giulio Toffoli - gt78 RE: ireport-lpad 2003-10-21 04:29 write a java class that convert a number in words decaring it as follow: public MyTextFormatter{ static public String lpad(String str, int len, String padder) { // your code here return str; } } Then in your textfield write an expression like: MyTextFormatter.lpad( $F{MyTextField}) Giulio

By: Mastin - pmastin Run Ireport (with current connection) 2003-10-20 03:11 The compile is Ok but generate (PDF, HTML, other) compile OK but the report is not available to view the result. Help me ! By: Giulio Toffoli - gt78 RE: Run Ireport (with current connection) 2003-10-21 04:25 Have you set the program to view the result? What version of iReport? Giulio

By: Flavio Giovanni - fgiovanni wrong version 48.0, should be 47.0 2003-10-16 07:01 Hello people. When i compile my report, the iReport return a error: C:Documents and SettingsFlavioDesktopmySQLmysql-connector-java-3.1.0-alphaUntitled_report_1.java:24: cannot access java.lang.Object bad class file: C:Arquivos de programasJavaj2re1.4.0librt.jar(java/lang/Object.class) class file has wrong version 48.0, should be 47.0 Please remove or make sure it appears in the correct subdirectory of the classpath. private JRFillParameter parameter_REPORT_CONNECTION = null; ^ 1 error dori.jasper.engine.JRException: Errors were encountered when compiling report expressions class file: See error messages above. at dori.jasper.engine.design.JRCompiler.compileReport(JRCompiler.java:148) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:135) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:123) at IReportCompiler.main(IReportCompiler.java:119) Abnormal termination! How to adjust this problem? Thanks - Flᶩo By: Giulio Toffoli - gt78 RE: wrong version 48.0, should be 47.0 2003-10-17 01:48 Stai compilando usando la versione 0.4.8 di jasperreports e nel tuo ambiente di produzione hai la varione 0.4.7 della stessa libreria. Devono essere uguali! Giulio By: Flavio Giovanni - fgiovanni RE: wrong version 48.0, should be 47.0 2003-10-17 11:23 Sorry, but i don't no what i need change... What do i need change in my project? Thanks - Flᶩo By: Giulio Toffoli - gt78 RE: wrong version 48.0, should be 47.0 2003-10-21 04:16 You must be sure that jasperreports.jar used by ireport is the same used by your application. Giulio

By: Zell Miller - misterz iReport 0.2.2 and Japanese Text 2003-10-18 18:09 I'm trying display some Japanese text in my HTML & PDF reports. For some reason, all my dynamic fields display ???? in HTML reports and junk in PDF. I used the suggested HeiseiKakuGo-W5 font and that still doesn't work. Is anyone aware if JasperReports .5 has Unicode bugs? Here is the generated XML Thanks Z... <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="SansSerif" pdfFontName="HeiseiKakuGo-W5" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="UniJIS-UCS2-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["u00e6u0153u00ac u00e8u00aau017e"]]></textFieldExpression> </textField>

By: huey miin - khmiin SQL queries supporting java function? 2003-10-12 10:15 how to write a proper sql statement: select * from studentMaster where registerDate <= $P{date} registerDate column in the database is in STRING type but the date parameter pass in is DATE type. So how can i include java function to convert the STRING type to DATE type in the sql queries? i found out the following syntax cannot work: select * from studentMaster where (new SimpleDateFormat("MM/dd/yyyy").format(registerDate)) <= $P{date} By: Mark Rhodes - mrhodes2 RE: SQL queries supporting java function? 2003-10-17 11:45 select * from studentMaster where registerDate <= convert(varchar(12,$P{date},101) You have to use valid SQL functions in the query.

By: vivek srinivasan - viveksrinivasan accessing 2 tables 2003-10-15 08:32 Hi, Is there a way where in i can access 2 tables from the same database.ie.Does ireport support nested query where in the subquery selects the data from another table Vivek By: Mark Rhodes - mrhodes2 RE: accessing 2 tables 2003-10-15 08:45 Assuming you are using some form of SQL, best way to accomplish this is create a view, then use the view in iReports. I have reports useing data in multiple tables and even from multilpe servers. By: vivek srinivasan - viveksrinivasan RE: accessing 2 tables 2003-10-15 09:45 I did create a view for the table.The actual table(fiscalyr) is in a database called info.I created a view in a database called pos and named the view as fiscaalyrview. but in the query when i do a select * from fiscalyrview it says "invalid object name" By: Mark Rhodes - mrhodes2 RE: accessing 2 tables 2003-10-17 11:41 this is not an iReport problem. try select * from pos.dbo.fiscalyrview otherwise you may have rights or jdbc issues

By: Nemi Chandran - nemis_work Adding different coulums... 2003-10-17 08:42 Hi... I have a report like this... Rec Amt1 Amt2 Amt3 Total 1 10.0 12.0 50.0 --- 2 5.0 2.0 30.0 --- Now how do i addup the 'Amt' values from 3 coulmns and display it in the 'Total' coulum. Thanks. By: Mark Rhodes - mrhodes2 RE: Adding different coulums... 2003-10-17 10:51 create a variable By: Nemi Chandran - nemis_work RE: Adding different coulums... 2003-10-17 11:30 I did create a variable... I created a 'java.lang.Double' variable 'total' and assigned it this expression $F{field1} + $F{field2}... this did not work, it said cannot apply '+' to 'java.lang.Double' type.. i tried $F{field1}.doubleValue() + $F{field2}.doubleValue().. even this gave me an error saying incompatible type... cannot convert 'double' to 'java.lang.Double' Both my fields are of type 'java.lang.Double' By: Mark Rhodes - mrhodes2 RE: Adding different coulums... 2003-10-17 11:39 new Double($F{field1}.doubleValue() + $F{field2}.doubleValue()) Case matters

By: willyw - willyw How to display data in dynamic column? 2003-10-17 03:39 Hi, I have a report format which does not have fixed number of column. It will only display when the value of the whole column does not contains value zero. For example, if column 2 contains all value zero, it should not occupied any space, but display value of column 3 right after column 1. Else, if column 2 contains non-zero value, it should display right after column 1. Hope to hear from all soon. Any help is very much appreciated. Thanks a billion!

By: vivek srinivasan - viveksrinivasan PLSQL 2003-10-16 06:46 Hi, i have generated a consolidated report which displays all the store#. The query i used was select * from emp group by store#; Now,I want to generate seperate reports for each store #. example:select * from emp where store#=1 select * from emp where store#=2 How can this be done?should i use PLSQL for this because i dont think ireports supports multiple queries,does it?? Thanks, Vivek By: Giulio Toffoli - gt78 RE: PLSQL 2003-10-17 02:01 You can use subreports. Giulio

By: mimisam - mimisam grouping and dynamic columns 2003-10-17 00:30 I need to make a report with the following format: Original data: method A method B method C day1 value day1 value day1 value day2 value day2 value format that is needed: method A method B method C Total day1 sumA sumB sumC sumABC day2 sumA sumB sumC sumABC ------ ------- -------- -------- totalA totalB totalC total questions: If day1 used method C and day2 didnt, sumC in day2 should be displayed as 0. If method C is not used in both day1 and 2, i dont want to display the column of methodC, how should i configure it so that it is dynamic? (eg. sometimes there can be 3 methods and sometimes less or more.)

By: Si Keen - swjkeen How to display Arabic text? 2003-09-27 04:07 I am reporting against an Oracle DB that holds some fields in Arabic. When I try to create the PDF report, having not chosen a specific Arabic font or codepage, the column containing the Arabic text is blank. However, having stepped through my Java application with a debugger, I can see that the Arabic has been fetched and it seems to be well formed. I am assuming that I just have to correct the display of this data. Can anyone give me advice as to what font and codepage to use, any other configuration, etc? By: Giulio Toffoli - gt78 RE: How to display Arabic text? 2003-09-29 06:13 Try to increase fields height. Giulio By: Hani Naguib - haninaguib RE: How to display Arabic text? 2003-10-16 14:26 Jasper Reports uses iText to generate pdf. IText does not have proper support for Arabic. To display Arabic I have had to use embed fonts (since the default fonts dont have the arabic characters). Unfortunately even when you have the correct font, the arabic is displayed in unconnected and inverted form. I am just finishing modifications to iText to get it to perform these tasks. If you are interrest (still beta) email me at hani@kylietech.com and I will send more details. By: Hani Naguib - haninaguib RE: How to display Arabic text? 2003-10-16 16:07 Ups, I take that back iText does have support for Arabic. You still need to embedded fonts, but it is capable of dealing with arabic characters (connecting etc..). I have not had time to see how this is achieved and why iReport and/or Jasper Reports does not seem to use this capability.

By: mozart - mozart_sk8 need help regarding utf-8 2003-10-12 17:40 Why is it everytime that I'm going to compile my ireport I always received an error message just like this: File: C:IReportiReport-0.1.0binTransactionSlip.xml Compiling to file... C:IReportiReport-0.1.0binTransactionSlip.jasper Oct 9, 2003 5:43:29 PM org.apache.commons.digester.Digester warning SEVERE: Parse Warning at line 1 column -1: Declared encoding "UTF-8" does not match actual one "Cp1252"; this might not be an error. org.xml.sax.SAXParseException: Declared encoding "UTF-8" does not match actual one "Cp1252"; this might not be an error. at org.apache.crimson.parser.Parser2.warning(Parser2.java:3148) at org.apache.crimson.parser.Parser2.readEncoding(Parser2.java:2946) at org.apache.crimson.parser.Parser2.maybeTextDecl(Parser2.java:2802) at org.apache.crimson.parser.Parser2.externalParameterEntity(Parser2.java:2880) at org.apache.crimson.parser.Parser2.maybeDoctypeDecl(Parser2.java:1167) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:489) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:373) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:337) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:323) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:121) at IReportCompiler.main(IReportCompiler.java:119) org.xml.sax.SAXParseException: Declared encoding "UTF-8" does not match actual one "Cp1252"; this might not be an error. at org.apache.crimson.parser.Parser2.warning(Parser2.java:3148) at org.apache.crimson.parser.Parser2.readEncoding(Parser2.java:2946) at org.apache.crimson.parser.Parser2.maybeTextDecl(Parser2.java:2802) at org.apache.crimson.parser.Parser2.externalParameterEntity(Parser2.java:2880) at org.apache.crimson.parser.Parser2.maybeDoctypeDecl(Parser2.java:1167) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:489) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:373) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:337) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:323) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:121) at IReportCompiler.main(IReportCompiler.java:119) NESTED BY : dori.jasper.engine.JRException: Declared encoding "UTF-8" does not match actual one "Cp1252"; this might not be an error. at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:397) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:337) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:323) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:121) at IReportCompiler.main(IReportCompiler.java:119) Caused by: org.xml.sax.SAXParseException: Declared encoding "UTF-8" does not match actual one "Cp1252"; this might not be an error. at org.apache.crimson.parser.Parser2.warning(Parser2.java:3148) at org.apache.crimson.parser.Parser2.readEncoding(Parser2.java:2946) at org.apache.crimson.parser.Parser2.maybeTextDecl(Parser2.java:2802) at org.apache.crimson.parser.Parser2.externalParameterEntity(Parser2.java:2880) at org.apache.crimson.parser.Parser2.maybeDoctypeDecl(Parser2.java:1167) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:489) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:373) ... 5 more Abnormal termination! What's wrong with my implementation? Am I missing something? I would really appreciate if you could help me tnx By: Hani Naguib - haninaguib RE: need help regarding utf-8 2003-10-16 14:30 Just a guess. Try saving your file using utf-8 encoding

By: Susan Lara - slara Not view subreports 2003-10-16 13:07 Hello I have a problem with the subreports, I call both to subreports from masterReport but I do not see them. The report Masters receives parametro Query, the subreports receive same parametro Query since I make the allocation or passage of this parametro to the subreports? Please... it´s very urgent!!!!!!

By: venkat - rashmivenkat subreport compile problem 2003-10-16 08:19 I made use of the subreport tutorial posted in the website.The way i wrote the query in the child report was select * from sqlTotals where store_id='$P{store_id}'.I even tried out with out the quotes like select * from sqlTotals where store_id='$P{store_id}'.It did not work? When i compile it i get the following error: java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Invalid parameter binding(s). atcom.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) atcom.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setInt(Unknown Source) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:288) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:391) at java.lang.Thread.run(Thread.java:536) NESTED BY : dori.jasper.engine.JRException: Error executing report query : select * from sqlTotals where store_id='?' at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:379) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:391) at java.lang.Thread.run(Thread.java:536) Caused by: java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setInt(Unknown Source) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:288) ... 4 more Abnormal termination! Please help...

By: Luciano Zanin - cianoz Startup.bat error msg (Windows platform) 2003-10-15 09:20 I always get this error when i try to run the startup.bat script (i have not Ant installed on my system): Exception in thread "main" java.lang.NoSuchMethodError at it.businesslogic.ireport.gui.JNumberComboBox.<init><JNumberComboBox.java:66> it.businesslogic.ireport.gui.MainFrame.initComponents<MainFrame.java:560> it.businesslogic.ireport.gui.MainFrame.<init>MainFrame.java:81> it.businesslogic.ireport.gui.MainFrame.main<MainFrame.java:4054> I have Java 2 SDK, SE v1.4.2_01 installed, full installation (it's the latest version) I have really no idea about how to solve this. Please, does anyone have a suggestion for this ? Thanks

By: Nemi Chandran - nemis_work Using result set.... 2003-10-14 08:26 Hi all... I'm trying play around with something.... I have got a table with the following fields... Store #, Transaction date and Transaction amoumt. Sample: store# tran_date tran_amt 001 date1 1000.00 001 date2 200.00 . . . . . . 001 date7 600.00 I'm trying to create a report that will list all the seven transaction for a week in a single line... like this.. Store # Date1 Date2 ..... Date7 001 1000.00 200.00 .... 600.00 002 ................ What i dont know is how to read multiple records and display it in a single line. Thanks.

By: Marcelo - mike81 Two pages in a single report. 2003-10-09 14:02 Hi. How I can include two pages in a single report (in the design).? I can do this? By: Giulio Toffoli - gt78 RE: Two pages in a single report. 2003-10-10 04:14 Not possible. Use a subreport to print the first page. This is not an ireport limitation, but a design choose of jasperreports that check that the sum of all bands is lower than the page height. Using subreports you can have no limit to the nymber of page of a detail band. Regards Giulio By: Dave Limer - limerdm RE: Two pages in a single report. 2003-10-13 11:55 Hi, Not sure what you mean about no limit using sub reports. I have to print a report which is about 6 specifically formatted pages. Seems like I can only use 1 subreport for each band (more than that won't print). So I think I'm limited to number of bands = number of subreports I can have. Or I'm not understanding (likley :) ). any info would be appreciated.

By: Matthew Dootson - dootson CSV file custom datasource: help! 2003-10-13 07:03 Please help me, I'm trying to read data into a report from a .csv file. The file is formatted like this: one;two;three four;five;six seven;eight;nine And I am using it.businesslogic.ireport.connection.CSVDatasourceTestFactory (getTheDatasource) as my connection, as described in ireport.sourceforge.net/cap4.html. I have set it as my active connection, but when I try to fill the fields in my report it says "Report design not valid: 1. Field not found: ..." should I be using $F{COLUMN_1} in my fields, or do the names come from the first row in the file? Or is there something I've missed? My CVSDataSourceTestFactory getTheDataSource() method is pointing to the correct file (I think): return new RCSVDataSource("e:\iReport-0.2.2\test.csv"); Any help would be greatly appreciated, I'm new to this (as you can probably tell!) Thanks, - Matt

By: Robert Casto - cincijava Feature Request: Better generation feedback 2003-10-10 07:10 It would be nice if iReport could give more feedback when generating a report. Currently it says that the report is compiled and how long it took. After a while, it will report that a PDF is being generated. I would like to see messages that tell me when the database was connected, that the report is being filled, and so forth. Maybe a setting to turn this on and off for those people who don't care to see the extra messages. I have some very long reports and it would be nice to know they are still being generated instead of having to wait a long time guessing if they will generate.

By: vivek srinivasan - viveksrinivasan query values in a variable 2003-10-09 09:54 Hi all, I have a query like select * from emp where trandatestart>='2003-08-05' and tandateend<='2003-08-10' I want to put the trandatestart and trandateend in the report page header.Is there a way where i can do this. My trandatestart and trandate end changes frequently.Can i put those values in a variable and then dispaly it in the report?? Thanks, Vivek By: Giulio Toffoli - gt78 RE: query values in a variable 2003-10-10 04:18 You should but this in two parameters, not in variables. In this way you can pass the value for your trandatestart and tandateend dinamically when you fill the report. Having this two values as parameters, in your header you can put two textfields with expressions like: $P{tandatestart} and $P{trandateend} Regards Giulio