yael

Thank you!!!!!!!!!!!

Hi, How can I connect parameter as string sql to the queryString ?? Code: strSql = " AND tasks.watch_date IS NULL "; Code:[code] <parameter name="strSql" isForPrompting="true" class="java.lang.String"/> <parameter name="owner_id" isForPrompting="true" class="java.lang.Integer"/> <queryString><![CDATA[sELECT * FROM tasks WHERE owner_id = $P{owner_id} $P{strDateSql}

Hi, I'm running viewReport from my java application. Code: JasperPrint jasperPrint = JasperFillManager.fillReport( jasperReport, parameters, conn); JasperViewer.viewReport(jasperPrint, true); My problem is when I'm closing the view report, my java aplication closing twe! I think it's because the view frame sel exit(0)? and one more question, if I run this viewReport from JButton in a JDIalog, the view location is under my dialog, how can I set this view to be allways on top?? Thanks alot :) Post edited by: yael, at: 2007/02/15 07:48

Hi, thanks!!! if I click on: menu>edit>insert>image It's work, I can see the image on the report, but I get runtime error: This error about if I add new Date() to the title, but I get the same error if I add Image.. net.sf.jasperreports.engine.JRException:ÂReportÂdesignÂnotÂvalidÂ:Â ÂÂÂÂÂ1.ÂFieldÂnotÂfoundÂ:ÂField ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:267) ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144) ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105) ÂÂÂÂ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:529) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) Post edited by: yael, at: 2007/02/15 06:56

Yes, I can't find a browser to my icom/image file.. If you can tell me where is it. I whant to add with iReport or edit with my self, do you have an example for me? (code)

How can I check in the xml file this: If( $P{status_id} != 0) then to add WHERE filter. else don't use the WHERE Code: <parameter name="status_id" class="java.lang.Integer" /> <queryString> <![CDATA[sELECT task_id,status_id FROM tasks WHERE status_id = $P{status_id}]]> </queryString> :whistle:

Could you please give me an example for that? I'm new in xml issue, If you can past for me some code I'll be happy :kiss:

Hi, How can I add Logo company into the pageHeader?? I can't find nothing about this issue, is it possible?? Thanks.

How to set JasperViewer.viewReport(...) to be Always On Top? I whant that the viewReport will behaver like a dialog, How can I set this? (from java will be greate!!!) Thanks Post edited by: yael, at: 2007/02/13 11:12

I whant that the iReport will behaver like a dialog, How can I set this? (from java will be greate!!!) Thanks.;)

Hi, 1)How can I set an Icone/Image to a pageHeader? 2)How can I creat dinamic queryString parameters, I'm using JasperReport I mean something like this Code: public class Report { public Report() { // TODO Auto-generated constructor stub try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"«»); Connection conn = DriverManager.getConnection( "jdbc:«»sqlserver://matarotsrv:1111;databaseName=qm6", "aa", "aa"«»); // load JasperDesign from XML and compile it into JasperReport JasperDesign jasperDesign = JRXmlLoader.load("task1.jrxml"«»); JasperReport jasperReport = JasperCompileManager .compileReport(jasperDesign); HashMap parameters = new HashMap(); if(ownerId!= 0){ parameters.put("owner_id", new Integer(ownerId)); } if(!(ownerName.equals(null))){ parameters.put("owner_name", new String(ownerName)); }) JasperPrint jasperPrint = JasperFillManager.fillReport( jasperReport, parameters, conn); JasperViewer.viewReport(jasperPrint, true); } catch (Exception e) { e.printStackTrace(); } } Then, in the xml file - How can I connect to the WHERE statment only if this properties is full with data?? Code:[code] <parameter name="owner_id" class="java.lang.Integer" /> <parameter name="owner_name" class="java.lang.String" /> ... Where tasks.owner_id = $P{owner_id} AND tasks.owner_name = $P{owner_name} Thanks, Yael. ;)

I found the solution, Thanks anyway.

Hi, I whant to run the iReport from my java application. I think I'm missing somethimg.. I get this error: Java virtual machine launcher Could not fined the main class, program will exit. Code: public class runApp { Process proc; runApp() { String str = "C:\MyJava\iReport-1.3.0\iReport.exe"; try { proc = Runtime.getRuntime().exec(str); if (proc.waitFor() != 0) { System.err.println("Program did not finish properly"«»); } } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } public static void main(String[] argz) { new runApp(); } } I'm thinking that I'm missing some file to complite iReport running. (with this code I get the same error). maybe I need add to this code more files to run the iReport? I get this error when I'm running this code, and I was try to check if it is about my code (not attached to java): If I coppy to some place in the computer only the iReport.exe file - then click on it to run this program, I get this error to. but if I'm running from the shortcut desctop or from the exe that located in the iReport directory (whit no attached to java) it's running good. so, I think this error dialog attached to iReport program. Post edited by: yael, at: 2007/02/13 06:20 Post edited by: yael, at: 2007/02/13 07:12

I mean, how to create jrxml file from java? I whant to open editor like iReport, is it possible? Thanks.:huh: To show this file I'm using white JasperViewer.. but I can't find nothing about edin jrxml file in my program (the user could edit jrxml).

Do you have an example for that? I don't fully understan. In my program I'm useing with JasperReports and show the report with JasperViewer. I whant to be able to edit a new report from my java program, I mean: if I clicked on the JButton, for example - I whant that the iReport will open to me :whistle: Thanks, Yael.