shreelu11

Hi Thanks for your suggestions. but nothing seems to be working out for my senario. I designed a sub report which displays Paytype Description and Total amount in the detail band using report query. I placed my sub report in the summary band of my master report but i got error while filling the report . Code: Error filling print... Error loading object from file : E:Program FilesJavaJboss-Eclipse-1.6.0workspacePOSsrcwebrootreportsMonthly SummaryMothlySalesSummaryByPaymode_sub.jrxml net.sf.jasperreports.engine.JRException: Error loading object from file : E:Program FilesJavaJboss-Eclipse-1.6.0workspacePOSsrcwebrootreportsMonthly SummaryMothlySalesSummaryByPaymode_sub.jrxml at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:92) at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:257) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:303) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:274) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:400) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummarySamePage(JRVerticalFiller.java:818) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:752) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:240) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:116) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:751) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:679) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:773) at java.lang.Thread.run(Unknown Source) Caused by: java.io.StreamCorruptedException: invalid stream header at java.io.ObjectInputStream.readStreamHeader(Unknown Source) at java.io.ObjectInputStream.<init>(Unknown Source) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:87) ... 15 more Print was not filled. Try using an EmptyDataSource... When compiled with empty DataSource i got the same error. i don't know what to do .. I also tried checking the field Paytype Description which is displayed in detail band of my master report. If it is Cash then i want to assign the field Amount to variable total_cash. so sum of total_cash will give me grand total of cash. I don't know if this is possible Any suggestions will help.. Regards Sreelekha

hi I tried your suggestion but it din't work ... I like to know if it is possible to have two report queries one for the detail band and another for summary band. or is it possible to assign field value to a variable only if some condition is true. Regards, Sreelekha. Post edited by: shreelu11, at: 2007/10/05 08:48

hi I tried your suggestions but the total cash variable reset at group gets reset for every record as records are grouped by payment date. ie for a particular date cash and credit payments are displayed. it will display for the no. of days the user pefers. At last in the summary band i have to calculate the total cash and total credit how do i do this.... Any suggestions will be helpful Regards Sreelekha

hi I have payment type field and amount field which is displayed in detail band. I have a variable for Sub total in Group band . My problem is that i have to calculate Total Cash and Total Credit separately in summary band.. which i am not able to do it..... Any suggestions will be helpful Please refer to attached file for refrence Regards Sreelekha [file name=Monthly_Sales_Summary_By_Payment_Mode.pdf size=1815]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Monthly_Sales_Summary_By_Payment_Mode.pdf[/file] Post edited by: shreelu11, at: 2007/09/29 11:42

Hi I need to display a report in a html page. Is it possible to embed a jasperviewer. help me out how to do it. Iam using jasperreports-1.3.0 jar Regards, Shreelu.

Hi Iam on the printing a jasper report using a servlet. I have to pass parameter to the report query as the sql changes according to user input. i have designed my report using ireport 1.3.0 and i have a parameter called payment_date in my report. Exception i got is java.sql.SQLException: No parameters defined during prepareCall() net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query Code:// create a map of parameters to pass to the report. Map parameters = new HashMap(); parameters.put("payment_date", payment_date); InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("/reports/Daily Sales By Pay Mode.jasper"«»); jasperPrint = JasperFillManager.fillReport(reportStream,parameters, conn); JasperPrintManager.printReport(jasperPrint, true); Iam printing the report from JSF and the parameter is passed using servlet. parameter is passed successfully. exception occurs when JasperFillManager.fillReport step is encountered. plz Suggest me how to solve the problem . any sample code will also help. cheers Shreelu

hi I am using ireport version 1.3.0,jasperreports1.3.0 version and developing jasper reports using servlet and have to export the report in xls format. while doing it i had a class not found exception poi. Wat version of poi should i use or using a higher version of jasper reports will do the purpose. waiting for a good suggestion.. Regards, Shreelu

ya, I have sat a active connection. I gave a sql query in report query, I am doubtful if i have to specify $F{pay_mode}and $F{amt}in the query in place of the database field name and bind the fields of ireport and database fields anywhere else.. Pls let me know how to do that.

Hi Iam new to iReports,Doing my first report. I designed the report with two Text Fields called $F{pay_mode} and $F{amt} and i have given sql query in report query to fetch data from the DB. I don't know how to bind the query fields to ireport fields. plz let me know how to do this. Regards, Sreelekha.