2005 IR Help

By: svensch - svensch Sample for Using IReport with Java Web Start 2005-10-27 15:55 Hello! Could someone post a simple sample file how to configure iReport to be launched via Java Web Start from a Website? - Is it possible to access MySQL-Connections from the server? - Is it possible to store/load Report-Definition-Files directly to the server? (or this is a feature request :) Thank you! Sven

By: feryshirano - feryshirano How to create a pattern? 2005-10-22 19:19 Hi, well I have a problem, I need to display a field like this: 445.444.465-77. But in the ireport there isn't a pattern like this? Can I create one like this?If I can, how can I do it? By: wytianjiao - wytianjiao RE: How to create a pattern? 2005-10-26 21:02 You can type it in the input box manually. But do follow the key words。 By: feryshirano - feryshirano RE: How to create a pattern? 2005-10-27 09:04 。 ? How can I do that?

By: miami - enrico1985 help iReport jump page 2005-10-26 06:49 how I make to make a jump page with a field contained in the Page Header? exists check a START ON NEW PAGE like for the normal groups? please help-me come faccio a fare un salto pagina con un campo contenuto nel Page Header?esiste un check START ON NEW PAGE come per i gruppi normali? By: miami - enrico1985 RE: help iReport jump page 2005-10-27 01:32 you must create a new group and put where you want, to must reduce to 0 its band for don't stamp it, adn after that you check Start On new Page and in Group expression yuo must put the field interested

By: Dharmendra Sharma - dkumar_sharma how to find out the column total 2005-07-12 00:01 Hi All, I need to implement the total of a particular column , which is to be displayed at bottom any where inside the layout. Any one please help me out. thanks & regards, dkumar_sharma By: BrianS - brian9420 RE: how to find out the column total 2005-07-12 04:37 Create a variable that sums up your column field name. Brian By: Dharmendra Sharma - dkumar_sharma RE: how to find out the column total 2005-07-15 23:26 Hi Brian, I could create a variable but I am not getting how to do the sum of the column, can u please give me more detail. Assume that i have column like price ------- 10 (here column name is $F{price}) 29 30 ---------- total 59 wating for ur reply, thanks & regards, dkumar_sharma By: Dharmendra Sharma - dkumar_sharma RE: how to find out the column total 2005-07-15 23:59 Hi All, Thanks a lot, I got it. By: propsystem - propsystem RE: how to find out the column total 2005-09-02 21:47 i have problem to count different value in one column;e.g: Name Sex 1- Adam F 2-Peter F 3-Susan M i want to count how many female and how many male base on sex status.anybody can help me... By: miami - enrico1985 RE: how to find out the column total 2005-10-27 00:03 see my message of the total, there is the explanation of this case..

By: Michael J. Prichard - michaelprichard Create Series for Pie Chart? 2005-10-22 08:41 I have variables i would like to create a Pie Chart with. For example, I have: $V{total_size} = 1000 $V{something} = 300 I want make a pie chart with these....how do I create a series to put in the value expression? Thanks. By: wytianjiao - wytianjiao RE: Create Series for Pie Chart? 2005-10-26 20:04 http://www.devx.com/Java/Article/29309/1954?pf=true?<br See the "Reports with Charts".

By: hillary - wikkitt DB Probs.... 2005-10-18 08:09 Hey all, I'm trying to connect to a SQLServer DB that is also being used by my JAVA program. But iReport is not connecting. I have no probs connecting with a JDBC with my program but iReport gives a General problem: null Please chack your username and password. The DBMS is running? (it really does say "chack") I have created a new username and password, installed new drivers, restarted the DBserver and still not working. I have to connect through an ODBC. That's fine for a while but not for long. I've looked everywhere I can think of and found nothing. Any help would be great. Thanks By: hillary - wikkitt RE: DB Probs.... 2005-10-19 07:25 It's the SQL Server 2000 Type 4 JDBC driver dowloaded from microsoft.com. my con string is jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Test This is the same string my program uses and it works fine there. I don't see why it wouldn't work here. Thanks for the help By: hillary - wikkitt RE: DB Probs.... 2005-10-20 13:03 Ok, I reinstalled iReport and everything seems to work now, Thanks By: J. Brett Howell - jbretthowell RE: DB Probs.... 2005-10-18 11:01 Which driver are you using and what does your connection string look like? By: Mary - maryremillard DB connection error to derby dbmx 2005-10-21 15:30 I'm using IReports (0.5.1) for the 1st time and I'm having problems connection to my derby database. Since the driver wasn't listed I added it and then added the jar files to my class path. I'm using the following information for the connection: Driver: org.apache.derby.jdbc.EmbeddedDriver URL: jdbc:derby:C:/BLCode/gumbo/web/WEB-INF/etc/db/cloudscape/mapperDB User Name: blahblah Password: <null> When I try to create a report I get the following error: General problem: null Please check your username and password. Is your DBMS running? The null exception is coming from it.business.ireport.gui.WizardDialog(1119) Anybody have any suggestions? Thanks. By: Giulio Toffoli - gt78 RE: DB Probs.... 2005-10-26 15:15 iReport is not able to set a null password. Use a blank password instead and check "save password". When you create the datasource, test it with the proper button. Giulio

By: hillary - wikkitt External Class question 2005-10-26 08:21 Where do I put an external class for my report to use? Do I have to create a jar file? I tried putting my class file in the lib folder but ireport won't read it. I need to pass the class a comma delimited string of numbers. A method will then break up the string and put the individual numbers into a HashMap that the report can read. Thanks By: hillary - wikkitt RE: External Class question 2005-10-26 10:18 Hi all, Ok, I got my report to read the class, but my method is not working. I read in the manual(pg96-97) that if you passed a $P{} to the external method, it would be passed as a map object and I could add to it so my report could access the processed data. I'm just testing right now but here's my code: public class ReportHelper { public ReportHelper() { } public static Boolean myName(Object map){ String key = "my_name"; String name = "Mud"; ((HashMap)map).put(key,name); return true; } } I placed a textfield on my report and in the "Print When expression" I put: (ReportHelper.myName($P{my_name})) But apparently iReports doesn't send it as a map, but sends the value of that parameter instead. Like i said above, I need to send it a srting of numbers and return the individual numbers plus some math results from those numbers. Any suggestions?

By: newbie - bkapur Doing case statements within SQL 2005-10-26 08:49 Hi, I am using iReports with a JDBC connection to a Mysql database. I have some existing mysql scripts that I am converting to iReports. Most of these scripts use a case keyword within the select. iReports does not seem to support the case statement, it gives a sql syntax error. Is theer any way I can get around it ? TIA Newbie

By: miami - enrico1985 how I make to eliminate the fields? 2005-10-20 00:40 how I make in order to eliminate the fields if these are null?and to eliminate the entire line, if they are more than one to being null? come faccio ad eliminare i campi se questi sono null?e come faccio ad eliminare l'intera riga di un detail se ce ne sono 2 o + ke sn null?? thanks By: miami - enrico1985 RE: how I make to eliminate the fields? 2005-10-26 06:23 you must check Blank when null and remove line when blank for eliminate this line,in plus you have to put the condiction in the field

By: Juha - juharossi v0.4.1 PDF exporter autoshrink blank space 2005-10-26 05:14 Hello, I have an autoexpanding textfield at bottom of report and I have "reserved" blank space just below that textfield for it to "expand" (It seems that report itself cannot "autoexpand" depending on content). HTML-exporter shrinks that blank space off at runtime, but PDF/RTF-exporters wont do that. I have an ugly "gap" at end of my report, how to get rid of it? Im using iReport 0.4.1 and JasperReports 0.6.6. Thanks in advance -Juha

By: miami - enrico1985 how are made x to change page? 2005-10-26 04:04 how are made x to change page based on the content of a field?I have a field in the PageHeader and based on this I must or less jump page how I can make? ho un campo nel PageHeader ed in base a questo devo o meno saltare pagina come posso fare

By: Porsche996GT2 - porsche996gt2 How to create a second page. 2005-10-21 09:49 Hello, I'm trying to create a second page on I-Report. How do you do it? Do I have to create a sub report to create a second page? TIA for any info. Thanks! By: sagi7 - sagi7 RE: How to create a second page. 2005-10-25 23:59 You are right - use a subreport. best regards

By: ldecaro - ldecaro Report in Excell ! 2005-10-25 11:06 Good day everybody! I'm having some trouble trying to generate a report in excell. This report was firstly designed to be generated as a pdf document in iReport. It's a complex report with 4 aggregation levels (each level implemented as a subReport). What I realized when first generated this same report as an xls document is that it is breaking lines, supressing data information and even not showing _two_ subreports data. Is there a _best practices_ doc where a can find out what i'm doing wrong ? I noticed that it seems to have a correct way to dispose components in the report design but... Cheers 'n' luck for all, :LuizDecaro.

By: Sven van Bevern - sbevern Bug -saving column width of report properties 2005-10-25 01:24 Hi ! I am using IReport 0.5.1, and I have designed a report (A) including subreport(B). The Report(A) has page width = 565, the subreport(B) width=510. If I go at subreport(B) to screen "report properties"; chapter colums (Report colums) the width of 565 is display. If I press ok, a collumn size greater then report size will be saved to jrxml. Depending on this following message appears while compiling: "net.sf.jasperreports.engine.JRException: Report design not valid : 1. The columns and the margins do not fit the page width. at net.sf.jasperreports.engine.design.JRJdtCompiler.compileReport(JRJdtCompiler.java:146) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:129)" If i reduce the report size to 510 all is correct, but at next opening of properties sheet the old value of 565 appears. Is there somebody who alreadey has this bug ? Sven By: Sven van Bevern - sbevern RE: Bug -saving column width of report proper 2005-10-25 01:33 Sorry I am new at IReport-Forum, I posted this thread also to Bugs section, but some answer are still good ;-) Sven

By: djiska - djiska Create component dynamicly 2005-10-16 12:04 Hi I' m going to do a question. But not to know if I can do it. Now I'm going to explain I want to do.I' ve got a form where I choose the database's columns. I want to create the components of the report dynamicly according to the columns I choose in the form. The report so it is dynamic not static. Can I do that? If I can it. How can i do it? Thanks in advance. By: Lukus - lukus2 RE: Create component dynamicly 2005-10-16 14:42 Hi there, Use alias for each column and pass in the column names as parameters. eg,,, SELECT $P{COL_1} AS column1, $P{COL_2} AS column2, $P{COL_3} AS column3 FROM ***** Hope this does the trich for you Lukus By: djiska - djiska RE: Create component dynamicly 2005-10-17 12:29 I think it is a good idea. But number of columns can vary between 2-10. So that it is ok if you know the number of columns but it is not the case, I think. if I am wrong you can tell me how. I have thought to put all the columns and to enable I use and each column aligns a pixel more than the last enabled. But I`ve got a trouble I don`t know to access to the components of the report. Does anybody Know how can i access to the component?. Or if do you have got any another idea? tell me it, please. thank you very much for you interest. By: Motoko2501 - motoko2501 I have a question related with the previous 2005-10-24 03:32 once i have created the report, how do i 'pass' the variables to it from the program? I mean, how should be written the sentece: parameters.put(X); So that the report gets the columns names?

By: Michael J. Prichard - michaelprichard Decoding XML Encoded String for display? 2005-10-22 07:21 I have a $F{} that looks like this when printed: <john.smith@foo.com> It is XML encoded in the database. How do I unencode so it looks like: <john.smith@foo.com> I figure it is a Print Expression but I am not sure what to do. Thanks, Michael

By: foikim - foikim Unknown Exception - Please Help 2005-10-14 02:13 When deploy the Jasper Report to IBM AIX machine, it thrown the exception : 0000003a ServletWrappe E SRVE0068E: Could not invoke the service() method on servlet ReportServlet. Exception thrown : java.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironment at java.lang.Class.forName1(Native Method) at java.lang.Class.forName(Class.java(Compiled Code)) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:91) at net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:58) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:464) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.<init>(JRHorizontalFiller.java:96) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.<init>(JRHorizontalFiller.java:78) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:108) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperManager.fillReport(JasperManager.java:692) at com.cityline.servlet.ReportServlet.doPost(ReportServlet.java:556) at com.cityline.servlet.ReportServlet.doGet(ReportServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332) [10/14/05 16:32:57:764 GMT+08:00] 0000003a WebApp E SRVE0026E: [servlet Error]-[ReportServlet]: java.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironment at java.lang.Class.forName1(Native Method) at java.lang.Class.forName(Class.java(Compiled Code)) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:91) at net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:58) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:464) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.<init>(JRHorizontalFiller.java:96) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.<init>(JRHorizontalFiller.java:78) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:108) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperManager.fillReport(JasperManager.java:692) at com.cityline.servlet.ReportServlet.doPost(ReportServlet.java:556) at com.cityline.servlet.ReportServlet.doGet(ReportServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332) By: bgriff - bgriff RE: Unknown Exception - Please Help 2005-10-21 05:45 If this is a headless server make sure you have an X11 graphics environment like Xvfb (Xserver virtual frame buffer) running. By: Elanchezhian - elanchezhian RE: Unknown Exception - Please Help 2005-10-17 02:51 Is it on on Unix / Linux environment? By: foikim - foikim RE: Unknown Exception - Please Help 2005-10-21 19:52 It's on Unix Environment

By: luis - luisatmd ERROR java.io.IOException: javac jasper 2005-10-21 10:50 I have a problem when i run my reports in Linux Red Hat AS , whith an application running on OAS 10g, the server display flollow message: java.io.IOException: java.io.IOException: javac: not found 05/10/19 16:42:36 at java.lang.UNIXProcess.<init>(UNIXProcess.java:143) 05/10/19 16:42:36 at java.lang.Runtime.execInternal(Native Method) 05/10/19 16:42:36 at java.lang.Runtime.exec(Runtime.java:566) 05/10/19 16:42:36 at java.lang.Runtime.exec(Runtime.java:491) 05/10/19 16:42:36 at java.lang.Runtime.exec(Runtime.java:457) 05/10/19 16:42:36 at net.sf.jasperreports.engine.design.JRJavacCompiler.compileClass(JRJavacCompiler.java:59) 05/10/19 16:42:36 at net.sf.jasperreports.engine.JRException: Error compiling report java source file : /oracle/10g/asserver/j2ee/home/LibDiario.java 05/10/19 16:42:36 at net.sf.jasperreports.engine.design.JRJavacCompiler.compileClass(JRJavacCompiler.java:84) 05/10/19 16:42:36 at net.sf.jasperreports.engine.design.JRAbstractClassCompiler.compileReport(JRAbstractClassCompiler.java:117) 05/10/19 16:42:36 at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105) 05/10/19 16:42:36 at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:211) 05/10/19 16:42:36 at com.santamaria.report.pojo.ReportePojo.getPDFBytes(ReportePojo.java:744)

By: hillary - wikkitt Convert comma delimited string to $P{}s 2005-10-20 13:36 Hi all Sorry to bug ya'll but I got some questions, I have comma delimmited string of integers that I need to break up for my report. ex. 1,4,10,5,9..... My program already has a class that converts the srting to an ArrayList and back again, and I can eaily make a method to break up the string and add it to an empty HashMap passed to it. My questions : a) Where do I put that external class for iReport to access. The lib folder? b)These strings can hold up 30 integers, do I declare 30 $P{}s in my report just in case? c)Do I put the external class call in the "Print When Expression" area, as long as my value is false, or somewhere else? Any help would be great! Thanks By: Marcelo Moniz - marcelomoniz RE: Convert comma delimited string to $P{}s 2005-10-20 16:04 Hi Hillary, i think you don't need a external class... Please, declare one String parameter on iReport: on iReport click on "View' -> Report Parameters -> New... and set your parameter: param name: paramStr (for exemple) parameter class type: java.lang.String in your class code(Action etc) write: Map mapParameters = new HashMap(); //put your String on mapParameters String yourString = "1,2,3,5,9"; mapParameters .put(paramStr , yourString );//for example byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(), mapParameters, con);//for exemple And back to iReport... and click on Datasource -> Report Query ... and write your query (for exemple) : SELECT * FROM clients WHERE client_id IN ( $P!{pameterStr} ) //pay atention for the exclamation point "!", dont forgive it -> $P!{parameterStr} and, so, your sql generated will be:: SELECT * FROM clients WHERE client_id IN ( 1,2,3,5,9) /* excuse me for my poor english */ By: hillary - wikkitt RE: Convert comma delimited string to $P{}s 2005-10-21 06:44 Thanks Marcelo, but that's not quite what I'm trying to do. I'm pulling these srtings from the db, then I need to count the occurance of each number from all records.. ex. record 1 = 1,3,5,7,15 record2 = 2,3,5,8 record3 = 1,5,8,11 I need a count of all the numbers: two 1's two 3's two 8's three 5's.... This count of each number then goes into the report. When my program handles these strings it breaks it up into an ArrayList of numbers but I don't htink that helps me here. Should have said that before, sorry. Any sugestions?

By: feryshirano - feryshirano Error with IReport 2005-10-21 04:29 I was trying to use Wizard Report and returned me this error: Compiling to file... .NovoRelatorio.jasper -> C:iReport-0.5.1NovoRelatorio.java Errors compiling .NovoRelatorio.jasper! it.businesslogic.ireport.ReportClassLoader@15b24dd net.sf.jasperreports.engine.JRException: Report design not valid : 1. Warning : Element bottom reaches outside band area : y=0 height=1 band-height=0 at net.sf.jasperreports.engine.design.JRJdtCompiler.compileReport(JRJdtCompiler.java:146) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:129) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:461) at java.lang.Thread.run(Unknown Source) What's wrong!!My objects are right in place. I don't know By: C-Box - c-box RE: Error with IReport 2005-10-21 05:14 Go to the the Object view in IReport and look for an element that is marked with red color... this one should be outside your band. hth C-Box

By: feryshirano - feryshirano How to receive only the answers of my posts? 2005-10-21 04:35 Is there a way to receive a notification (a mail) only of my posts?!?!Because I select the option "Monitor this Forum" and I receive all the posted messages from here. By: C-Box - c-box RE: How to receive only the answers of my pos 2005-10-21 05:11 Register at SourceForge... then you will get some "advanced" monitoring and search functions.... but don't know what these are! :-) hth C-Box

By: angelo - amlavides how to display an image stored in database? 2005-10-19 02:37 Hi all. How can i display an image, which is a field in our database, inside iReport. Currently the field has a datatype of 'image' and when I put it inside iReport and preview it, all i can see are the numbers representing that image. When we do this in Crystal we can see the actual image when we insert the field. Am i missing something here? Thanks for any help you can give... By: Lukus - lukus2 RE: how to display an image stored in database? 2005-10-19 14:33 Hi, One way would be to call an external java class that streams the field content to a tempory file and returns that file name and path. Just instantiate your object in the section where you have placed the $F{xxx} field. Cheers Lukus By: angelo - amlavides RE: how to display an image stored in database? 2005-10-19 18:12 thanks for the input Lukus.. but is there any other way without saving it to a temporary file? thanks.. -angelo By: C-Box - c-box RE: how to display an image stored in databas 2005-10-20 03:22 We do load all needed images from DB before calling the fill-method and work with parameter where each image is an parameter of type "java.awt.Image" ... so no files just objects.... but I guess you want to see your image in designer already.. but AFAIK this isn't possible yet. sorry C-Box By: Margaret - margaretv RE: how to display an image stored in database? 2005-10-21 04:48 If you can see the numbers, it sounds like your image is a java.lang.String class. Try changing it to java.io.InputStream.

By: elpablo - elpablo Optional table/graphs 2005-10-21 04:32 I have a requirement that a report collection be generated on the fly and the user can specify which reports they want in the collection and the reports can contain either the table, or the graph, or both on the same page with the graph at the top. I've tried this with subreports and kinda managed it by making a table and a graph as a subreport each and then having three different superreports(?) which contain the graph/table combinations. The problem with that is : I have to put the graph and table in the detail section and they get repeated for every row that is retrieved. Is there something that I'm missing here? Is there actually a way to do this without repeating all my elements in different files? Thanks in advance, Paul By: elpablo - elpablo RE: Optional table/graphs 2005-10-21 04:36 Ok, just after I posted this I realised I could just put both subreports into the summary band and it works. I'd be interested to know if anyone has any more elegant ideas that don't involve having three templates for one report though! Thanks, Paul

By: jane_lim - jane_lim Hyperlink to another PDF problem, pls help 2005-10-21 03:03 Hi, i have a pdf file in package com/company/file/abc.pdf i create a report call report.pdf in this report.pdf, i have a hyperlink to link to abc.pdf Hyperlink target:Self Hyperlink type: RemoteAnchor HyperlinkReferenceExpression : $P{PDF_FILE} HyperlinkAnchorExpression: "title" for parameter, PDF_FILE class type: java.net.URL in my application, i deploy the pdf file in a jar URL path = getClass().getResource("/com/company/file/abc.pdf"); parameters.put("PDF_FILE", path); it hit cannot cast java.net.URL to String i want to ask, why HyperlinkReferenceExpression must is String?? can it be java.net.URL??

By: Michael J. Prichard - michaelprichard First Report: Wrong database file version 2005-10-20 17:11 I am following the directions for the first report and I get a "Wrong database file version" when trying to hook up the northwind demo db. I know I have the path right... using ireport 0.5.1 on Mac OSX. Any ideas? Thanks, -Michael By: Michael J. Prichard - michaelprichard RE: First Report: Wrong database file version 2005-10-20 17:18 Hi. How embarassing...I just answered my own question. For those out there that download the Northwind DB and then get this error... I created another folder (northwind2) and copied all the northwind files except for the northwind.properties file and redid the connection. worked prefectly. SO...remember to remove the .properties file and try again :) Thanks, -Michael