rbojja

Hi, I had worked with jrxml files in my java. But i want to reduce the compilation time of jrxml file converted to .jasper file. I want to use directly the .jasper file instead of jrxml file (.jasper is generated using iReport) Can any one give me a solution for this? i had searched the forum but i didnt get any.

Hi, I have a requirement such that the total sum amount should be printed in words. ie if my sum amount is 125.00 $ then it should print as "One Hundred Twenty Five" How is this possible in jasper? or any ways of doing it in Oracle

Hii Am getting the below exception when try to run the report.what might be the issue.I tried all the possibilities?can any one help me out..its urgent plz Query: is as follows! SELECT XMRH.MR_NUM ,XMRL.MR_LINE_NUM ,XMRH.MR_DATE ,XP.NAME ,XMRH.LOCATION ,XMRH.EMP_NUM ,XMRL.MR_LINE_ID SEQ_NUM ,XI.SEGMENT1 ITEM_CODE ,XI.DESCRIPTION ,XI.PRIMARY_UNIT_OF_MEASURE UOM ,REQUESTED_QTY QTY ,XMRL.STATUS ,XE.FULL_NAME REQUESTED_BY , CB.EMP_NUM PREPARED_BY , UB.EMP_NUM APPROVED_BY FROM XXSEW_MR_REQ_HDR XMRH ,XXSEW_MR_REQ_LINES XMRL , XXSEW_LOCATIONS XL ,XXSEW_OA_LOC_USERS CB ,XXSEW_OA_LOC_USERS UB ,XXSEW_ITEMS XI ,XXSEW_PROJECTS XP ,XXSEW_EMPLOYEES XE WHERE XMRH.MR_NUM =XMRL.MR_NUM AND XMRH.REQUESTED_BY = XE.PERSON_ID AND XI.INVENTORY_ITEM_ID=XMRL.ITEM_ID AND XI.ORGANIZATION_CODE = XMRH.LOCATION AND XI.ORGANIZATION_CODE = XL.ORGANIZATION_CODE AND XMRL.CREATED_BY = CB.EMP_ID (+) AND XMRL.LAST_UPDATE_BY = UB.EMP_ID (+) AND XMRH.PROJECT_ID =XP.PROJECT_ID AND XMRL.STATUS = NVL($P{status},XMRL.STATUS) AND XMRH.MR_NUM LIKE NVL($P{mrNumber},XMRH.MR_NUM) AND XMRH.PROJECT_ID = NVL($P{projectId},XMRH.PROJECT_ID) AND XMRH.MR_DATE = NVL($P{mrDate},XMRH.MR_DATE) ORDER BY XMRH.MR_NUM, XMRL.MR_LINE_ID Error trace: net.sf.jasperreports.engine.JRException: Unable to get value for field 'MR_DATE' of class 'java.sql.Timestamp' at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:314) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:787) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:751) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1438) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:895) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:798) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at com.osi.sew.model.ReportBean.materialRequisition(ReportBean.java:169) at com.osi.sew.servlet.InventoryReportServlet.doPost(InventoryReportServlet.java:72) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at oracle.lite.web.JupServlet.service(Unknown Source) at oracle.lite.web.AppServletHandler.handle(Unknown Source) at oracle.lite.web.JupApplication.handle(Unknown Source) at oracle.lite.web.JupApplication.service(Unknown Source) at oracle.lite.web.JupHandler.handle(Unknown Source) at oracle.lite.web.HTTPServer.process(Unknown Source) at oracle.lite.web.HTTPServer.handleRequest(Unknown Source) at oracle.lite.web.JupServer.handle(Unknown Source) at oracle.lite.web.SocketListener.process(Unknown Source) at oracle.lite.web.ClientListener.process(Unknown Source) at oracle.lite.web.SocketListener$ReqHandler.run(Unknown Source) Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] at java.sql.Timestamp.valueOf(Unknown Source)

Hi All, When i try to open the pdf in jasper viewer the below expection is seen and the jviewer hangs/doesnt respond? Can any one tell me where the issue is? code: JasperPrint jasperPrint = JasperFillManager.fillReport(masterreport, parameters, conn); JasperViewer.viewReport(jasperPrint,false); Error log: 09/07/10 14:56:14 java.lang.NullPointerException 09/07/10 14:56:14 at net.sf.jasperreports.view.JasperViewer.exitForm(JasperViewer.java:239) 09/07/10 14:56:14 at net.sf.jasperreports.view.JasperViewer$1.windowClosing(JasperViewer.java:198) 09/07/10 14:56:14 at java.awt.Window.processWindowEvent(Window.java:1121) 09/07/10 14:56:14 at javax.swing.JFrame.processWindowEvent(JFrame.java:266) 09/07/10 14:56:14 at java.awt.Window.processEvent(Window.java:1079) 09/07/10 14:56:14 at java.awt.Component.dispatchEventImpl(Component.java:3615) 09/07/10 14:56:14 at java.awt.Container.dispatchEventImpl(Container.java:1627) 09/07/10 14:56:14 at java.awt.Window.dispatchEventImpl(Window.java) 09/07/10 14:56:14 at java.awt.Component.dispatchEvent(Component.java) 09/07/10 14:56:14 at java.awt.EventQueue.dispatchEvent(EventQueue.java:458) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) 09/07/10 14:56:14 at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

No one answered this question. Is this not possible?

HI all, I have a scenario where i need to show all the values of master report on the subreport. for example i am having scanCode values in detail band 1,2,3,4 in master report. i need to show the same values on subreport. i had tried with various option but all i see is the last value. I need to show all the values of 1,2,3,4. please its urgent

now its ok .... :)

it always displays only one image....not following the condition

got it .. under image tab - > image expression i added this expression...and got the result. $F{banner}.equals("Rogers & Hollands")?"C:\Receipts_Stores_New\AOLOGO-w-dia--Con_small.jpg":"C:\Receipts_Stores_New\RH-LOGO-w-dia--(2)_small.jpg"

hello, $F{StoreName}.equals("ABC")?"YourImageABC.jpg":"YourImageDEF.jpg" is what i tried.But issue is how to get the location of the image to display. I tried as $F{StoreName}.equals("ABC")?"C:\Images\YourImageABC.jpg":"C:\Images\YourImageDEF.jpg" ...but it is not displaying any image. it only prints the image name for the condition...am i missing any thing? should i try with image field or text field?

HI, i have a requirement to show the image/logo on the report. If i get store name as ABC then show an image/logo else if store name is some xyz show another image/logo. How should i display the image at the same location on the report based on the above condition?

HI i had queried the forum and read all the messages posted here. But i didnt udnerstand any...so is the reason i asked for tech help. can you elaborate me the webapp sample step by step and explain to me...and how to resolve the issue of client side printing. through out the forum there are many posts for the similar client side prinitng. but no one has explained how to implement it? can you please do the needful

HI i had developed few reports using jasper for my web application. The web application follows MVC. Now when i click on my print button the code executes and the report is printed on default printer of server. Till here its fine but now i want to print this print object on my client printer. How do we acheive this here? Please help me on fixing this issue. If any one have solved in their projects...plz

can we have a subreport inside a subreport?

Hi I want to print a line only when the page count is greater than one. If its a single page report then dont print the line.But when more than one page then only print the line. how do we acheive this on a line to print. thanks,