salishs

Hi , I also has the problem with dynamic parameter passing ,ok iwill explain i want to get the data of a month so my query will be select * from fruit where month(shiftdate)=10; this will give me the needed result ,ok but if any date in that month eg:sundays are holidays so that day will be no data and also that date also missing i want that date also as in the date column ad the remain as 0.00,so i written a pgm in java to get alla the dates in a month and pass to the quey(not in report)as select * from fruit where shiftdate=2009-10-04; this is sunday so i get the output as sunday 0.0 0.0 in my java pgm but how can i pass the dates dynamically or is there any option other than this .I'm using ireport 3.0.0 Please help me

Hi , I also has the problem with dynamic parameter passing ,ok iwill explain i want to get the data of a month so my query will be select * from fruit where month(shiftdate)=10; this will give me the needed result ,ok but if any date in that month eg:sundays are holidays so that day will be no data and also that date also missing i want that date also as in the date column ad the remain as 0.00,so i written a pgm in java to get alla the dates in a month and pass to the quey(not in report)as select * from fruit where shiftdate=2009-10-04; this is sunday so i get the output as sunday 0.0 0.0 in my java pgm but how can i pass the dates dynamically or is there any option other than this .I'm using ireport 3.0.0 Please help me

Hi all, i had downloaded ireport 3.7 from http://sourceforge.net/projects/ireport/files/iReport/iReport-3.7.0/iReport-3.7.0-windows-installer.exe/download created a jasper and yun on the irepot it works fine and gives the out put . When i call the jasper from my java code the exception raised Exception in thread "main" java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Unknown Source) at java.lang.Class.getConstructor0(Unknown Source) at java.lang.Class.newInstance0(Unknown Source) at java.lang.Class.newInstance(Unknown Source) at net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:476) at net.sf.jasperreports.engine.JasperCompileManager.loadEvaluator(JasperCompileManager.java:242) at net.sf.jasperreports.engine.fill.JRFillDataset.createCalculator(JRFillDataset.java:411) at net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:405) at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:77) at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:59) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at com.salish.CheckReport.(CheckReport.java:43) at com.salish.CheckReport.main(CheckReport.java:65) my java code jrxml is also attaching in irpeort 3.6. and 3.7 also detail1 is there while in 3.0.0 only detail if the same done with 3.0.0 NO PROBLEM why?????????? Please help me

Hi, The same when done with irepor3.0.0 the jrxml is <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Check" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="50" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="30" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="100" isSplitAllowed="true" > <staticText> <reportElement x="96" y="42" width="181" height="31" key="staticText-1"/> <box></box> <textElement> <font/> </textElement> <text><![CDATA[Hello]]></text> </staticText> </band> </detail> <columnFooter> <band height="30" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="50" isSplitAllowed="true" > </band> </pageFooter> <lastPageFooter> <band height="50" isSplitAllowed="true" > </band> </lastPageFooter> <summary> <band height="50" isSplitAllowed="true" > </band> </summary> </jasperReport> see the difference pls use thisthanks

Hai This is the problem due to the jasper report 3.6.2 please use iReport-3.0.0 if u has and do the same if u got it then ok if any other error then pls replay me steps i do copied ur jrxml opened by my iReport-3.0.0 created the jasper and run by java got the output but iReport-3.6.2 it willl not that i'm also searching if u get any help pls replay thanks

Hai This is the problem due to the jasper report 3.6.2 please use iReport-3.0.0 if u has and do the same if u got it then ok if any other error then pls replay me steps i do copied ur jrxml opened by my iReport-3.0.0 created the jasper and run by java got the output but iReport-3.6.2 it willl not that i'm also searching if u get any help pls replay thanks

Hi, i dwld ireport iReport-3.6.2 . There is detail1 on compiling and runing it will gave output , but when call by java pgm it wont display any thing in detail portion but others are working correctly why ?

Thank a lot for Your valuable help ,I got the formate that i want by your own help ,thanks a lot You had asked me a dought select name,date_format(date1,'%d') as date1,time1,date_format(date1,'%M-%y') as hdat from test.login where year(curdate()) and monthname(date1) like $P{mon} order by date1 asc i think the date_format is that problem in the table the field is varchar and in order yyyy-mm-dd so to use the patteren in the report wont give the correct formate that i want means dd-mm-yy so in mysql date_formate(date,format) will give in which formate we want the next date_formate will show the month and year this report had made The Output also attaching Thanks a Lot

Thanks for your replay , and give a new knowledge about the crosstab,i'm new in crosstab part so slight problem i thin in getting the data as per the requirement but i had done as per your instruction and i getting the result ,but the colums are only a few number means as per my query select name,DATE_FORMAT(date1,'%D %b %Y')as date1,time1 from test.login where year(curdate()) and monthname(date1) like $P{mon} order by date1 asc the month name is i am passing (October) but its not comming in a sorted order and another thing is that the date 01-10-2009 to 30-10-2009 is not printing in the straight formate earlier one that i attached , after the crosstab option the value or the output is ok i will attach what i got in crosstab option name in rows date on colims time on details funtion nothing the jrxml also i'm attaching,please go through it please excuse me ,for trouble you /tools/fckeditor/editor/images/smiley/msn/heart.gif please go through testspage.xls that is the actualiy i want Thank You Very Much for your replays

Thanks To your valuable replay The formate i want is attaching its now in xls Thank You

Thanks for your replay and sorry to say that i had mistaken you also Actually i want the report per month means if we took October then the date 1,2,3... on xaxis and each store on y axis so that per day how many qty that store had sold that was the main problem , please excuse me for the wrong info i posted sorry and thanks for your valuable replay please replay me for the actual problem Thank You

hi friends will any body please explain me how can i make the report in pdf in the formate (each store sale in each month).Please help me i am using iReport 3.0.0 Jan FEB MAR APR MAY Store1 10 20 30 40 0 Store2 0 0 50 0 60 Please help me Thanks In advance

hi friends will any body please explain me how can i make the report in pdf in the formate (each store sale in each month).Please help me i am using iReport 3.0.0 Jan FEB MAR APR MAY Store1 10 20 30 40 0 Store2 0 0 50 0 60 Please help me Thanks In advance

hi friends will any body please explain me how can i make the report in pdf in the formate (each store sale in each month).Please help me i am using iReport 3.0.0 Jan FEB MAR APR MAY Store1 10 20 30 40 0 Store2 0 0 50 0 60 Please help me Thanks In advance

/uploads/projects/jasperreports/image/salish/example.JPGHai friends will any body please explain me how can i make the report in pdf in the above formate (each store sale in each month).Please help me i am using iReport 3.0.0 Thank you Code: